What caused this? I have a worksheet that has several columns of numbers, when I opened it today all of the numbers were changed to dates. I had to reformat them back to numbers. Does anyone know what caused this ... 1 Mar 2010 19:53 Copy value according to date Hi, i have date from 01/01/10 in cell A. In Cell E mixed up dates with values in cell F. I want value from cell F copied to cell b when date in cell A and date in cell B match. please help A B E F 01/01/2010 02/01/2010 20 02/01/2010 12/01/2010 36 ... 1 Mar 2010 22:06 Formula Help I need to find how many times Dan occurs in a certain month. Example Below. A B 1 1/2/10 Dan 2 1/5/10 Dan 3 1/10/10 Perry 4 2/3/10 Perry 5 2/7/10 Dan 6 2/12/10 ... 2 Mar 2010 19:16 Unique Random List Here's a simple but elegant way to do this: Put the list of names in column A. I'm using 10 names but the list could be as long as you like if you adjust accordingly. In cells A1 through A10, enter numbers, names, or any list you want to randomize In cell B1, enter =RAND() and copy down to B10 In cel... 1 Mar 2010 18:46 Blank space I have big database of customers and have blank space beoire the customer name start. How can i remove it in bunch? Dinesh ... 2 Mar 2010 15:50 is there a simpler way to do this formula? =(F16*J16)+(F17*J17)+(F18*J18)+(F19*J19)+(F20*J20)+(F21*J21)+(F22*J22)+(F23*J23)+(F24*J24)+(F25*J25)+(F26*J26)+(F27*J27)+(F28*J28)+(F29*J29)+(F30*J30)+(F31*J31)+(F32*J32)+(F33*J33)+(F34*J34)+(F35*J35)+(F36*J36)+(F37*J37)+(F38*J38)+(F39*J39)+(F40*J40) first day back from maternity leave and my brain is not quite in e... 1 Mar 2010 18:46 calculate hours how do you calculate hours i.e. 3:45am-11:15am = ______hrs? ... 2 Mar 2010 04:37 Using Data Validation via an array to stop manual entries - possib My original problem is listedbelow I am using Data Validation for selected vehicles on runs, but I need to stop people assigning a duplicate registration for seperate runs. The list for the data validation is in cells D91 to D120 and the entries are made in cells H3 to H47 ALSO - on the same sheet I need to ... 2 Mar 2010 04:37 Look up table? I am sure this is simple, but I dont know how to achieve it I have 2 drop down lists the produce values 1-3 each and a table A B C 1 500 550 600 2 450 500 550 3 400 450 500 How do I get the value at the intersection o... 1 Mar 2010 14:09 Reference function from an out of sort table I'm looking for a reference function to pull the result from an out of sort table (see table example below). The result should always come from the reference value LT A14. The table is always a whole number 0,1000,2000,3000, etc. I've tried the following functions, but they all require data in ascending ord... 1 Mar 2010 16:29