I Really need help with formula I have CK4 Min. hours & CL4 Max hours & CM4 is going to = Differece between CK4 & CL4, CG5:CG65 =names & CJ5:CJ65 =hours remember hours & names belong together, Now what i want is to have Names transfered over to CK5:CK65 if greater than 28 from Min to Max & leave cells blank if less Also in CG5:CG65 for names ... 6 Jan 2010 22:10 macro for a range Hello all. Happy new year and welcome back to work. Appreciate if I can get help on the following: In Range A1 to A10 I have dates. In Range B1 to B10 I have a number between 1 and 100. I require a formula (or macro) in range C1 to C10 to count the number of days between today and the date in the correspo... 6 Jan 2010 19:56 vertical gridlines vertical gridlines are missing from an EXCEL column. I tried TOOLS, OPTIONS, and checked the Gridlines box. ... 7 Jan 2010 11:19 how do I get a cummulative total in excel I have a spreadsheet where I add daily totals. One of my columns is for a percentage for the day. At the bottom of the page I need a month to date average percentage. How can I do this. I have tried....(i.e. =AVERAGE (L4:L34)). This is giving me an average of all 31 days of the month instead of just the 5 that ... 6 Jan 2010 19:56 EXCEL FORMULA Need help with an excel formula. Cell A1 is 10 an input Cell B1 is 5 anther input Cell C1 is 5 but a formula A1 - B1 I want to only analize variances that are greater than 25% of cell A1. I can create this formula but only if C is a postiive number. If cell A1 is less than B1 then I'd also like to see t... 6 Jan 2010 15:27 IF formula with multiple data range in cell I'm trying to create an IF formula that returns data after searching a cell that contains more than one data range. For ex: Cell B3 contains GCVW-00001, GCVW-00002 I need the formula in C3 to return Yes if B3 contains GCVW-00001 and I need the formula in D3 to return Yes if B3 contains GCVW-00002 I'm able to... 6 Jan 2010 09:48 2010 date in Excel 2000 It appears that Excel 2000 does not like any year after 2009, as it tells me date is invalid. Is there a way to fix this ? ... 6 Jan 2010 09:48 leading zero -- Thanks, Jim ... 6 Jan 2010 09:48 My date is coming up 0-Jan-00 when I type current date. Why? ... 6 Jan 2010 09:48 Past Questions and Answers Hello How can I find out past questions and answers for a specific topic? I lost the answer to my question, which was posted here last week? thank you ... 6 Jan 2010 09:48