Pages

Search

Excel Help Forum - Excel General: Is there a way to apply conditional format if duplicate BUT only for a certai...

Feed2Mail notification - new post on Excel Help Forum - Excel General
Is there a way to apply conditional format if duplicate BUT only for a certain value?
I have a userform that's outputting data to a worksheet (schedules) and it's okay to have a duplicate schedule for someone unless it's a late shift (10:00pm, value is outputting as 10:00) in which case, I'd like conditional formatting to highlight the cells. I've messed with it but I can only do...

Excel Help Forum - Excel Charting & Pivots: X and Y avlue on scatter plot

Feed2Mail notification - new post on Excel Help Forum - Excel Charting & Pivots
X and Y avlue on scatter plot
hi, let me know how to calculate the extrapolite the value on linear graph? i m able to calculate the x and y at 0, but i wanted to know if the value at 20.9.Attachment 188931 (http://www.excelforum.com/attachment.php?attachmentid=188931)

Excel Help Forum - Excel Programming / VBA / Macros: Creating a list of single values from a list with multiples of that value

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
Creating a list of single values from a list with multiples of that value
Hello, I am not entirely sure that my problem falls under VBA/macros, but I am writing a macro, so here is the problem: I have a workbook which has lists of data for several buildings. The data spans several weeks and is labelled by the day and time that it was recorded. So there are about 100...

Excel Help Forum - Excel General: Wearout Determination

Feed2Mail notification - new post on Excel Help Forum - Excel General
Wearout Determination
I have this solved through some helper columns, but I was curious if anyone can deduce a single formula solution... Basically, I have a piece of equipment that can make 4000 units before it breaks. I have a yearly forecast of units needed. I would like to determine at what time the equipment...

Office IT Pro General Discussions Forum: mailmerge issues with coping excel spreadsheet

Feed2Mail notification - new post on Office IT Pro General Discussions Forum
mailmerge issues with coping excel spreadsheet
i am trying to make a mailmerge with my excel spreadsheet and word document. when i merge the two together, the word document has 12:00:00 AM where it should be blank information. how do i correct that. i have 2007 office

Excel Help Forum - Excel Programming / VBA / Macros: How to import data from webpage (from ajax)

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
How to import data from webpage (from ajax)
Dear Members, I would like to download data from the following webpage with ajax on that page. http://www.dukascopy.com/tradercontest/?action=liveForecast When I want to download data from page 2, the website does not generate a new web address and one of the great members have already...

Excel Help Forum - Excel Programming / VBA / Macros: Still learning arrays, not sure how to work with a particular range input/edit

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
Still learning arrays, not sure how to work with a particular range input/edit
Attached is the demo for a scheduler program I'm nearly finished developing. The final part I'm having to deal with is entering in a particular range of information (the start times and lunch times) from the userform (AddNew) into the active sheet and then using the EditPrior to pull the data back...
Subscribe to: Posts (Atom)