Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Maybe VLOOKUP?
Hi
I have a huge dataset, 10,000+ rows many times over, of date + hour. (i.e. 7/1/2004 16:00) The point of my data is that there is not a value for each consecutive date + time, some are missing. I need to format my data (for a statistical analysis program) so that one column shows every possible date + hour comnbination for a 2-year period, and another column shows a "1" or "0" for whether or not that date exists in my original dataset or not, respectively. For example, my data looks like this: 7/1/2004 1:00 7/1/2004 2:00 7/1/2004 4:00 7/1/2004 5:00 And I want it look like this: 7/1/2004 1:00 1 7/1/2004 2:00 1 7/1/2004 3:00 0 7/1/2004 4:00 1 7/1/2004 5:00 1 It seems like VLOOKUP is the answer, but I can't get it to work. Am I on the right track, but maybe have a formatting problem? Thanks for considering!! Ashley |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
Vlookup -=VLOOKUP(F9,LookUp1!$A$2:$B$1504,2,FALSE) | New Users to Excel | |||
IF(a1="x",(vlookup 18K rows,2,false),(vlookup 18K,3,false)) RAM? | Excel Worksheet Functions | |||
IF(AND(val1=VLOOKUP( );val2>=VLOOKUP( );val2<=VLOOKUP( );VLOOKUP( | Excel Worksheet Functions | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |