Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lookup to find the last value based on name and date field
Worksheet is called 'Raw Data'
Column A = Name Column B = Date Column D = Time I need a lookup to pull out the first time (for one cell) and last time (for another cell) based on criteria in a seperate worksheet ('Report') where A1 contains the Name to filter on, and B1 contains the Date to filter on. I used the fomula =LOOKUP(2,1/('Raw Data'!$A$2:$A$10000=$A$1),'Raw Data'!$D$2:$D$10000) to find the last time based on Name, but I don't know how to add the extra date criteria in. Thanks in advance for your help! -- Adam Thwaites Access Database Designer Manchester, UK |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup Hours from table based on date range... | Excel Discussion (Misc queries) | |||
Populating a field based on lookup values | Excel Worksheet Functions | |||
Add worksheet Lookup based on date | Excel Worksheet Functions | |||
sum multiple rows based on progressing date field on each row | Excel Worksheet Functions | |||
Need to find Min value based on date range entered | Excel Worksheet Functions |