| Home |
| Search |
| Today's Posts |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lookup date range row 1 and count if leave in same column on r
Welcome, good to hear
Had a typo earlier for this line: .. Enddate in AA2 It should read: .. Enddate in AB1 but I think you caught that <g -- Max Singapore http://savefile.com/projects/236895 Downloads:27,000 Files:200 Subscribers:70 xdemechanik -- "Pappa" wrote: Thanks Max. Your solution not only works but is concise...simple yet effective. I really appreciate the help. -- Cheers Pappa Smurf |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count Unique Values in 1 Column based on Date Range in another Column | Excel Worksheet Functions | |||
| Lookup / return latest date in range AND value of 1 column to the | Excel Worksheet Functions | |||
| 2 column lookup - match to date range | Excel Worksheet Functions | |||
| How to count dates within a certain range in a column with mutiple date range entries | Excel Worksheet Functions | |||
| Count cells based on date range in another column | New Users to Excel | |||
Threaded Mode
