Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Searching dates
To explain my question in a better way I have uploaded my worksheet on my
website http://www25.brinkster.com/shreejipc/Mihit/Book2.htm What I want to do is: Search all the five numbers 7 40 61 62 68 in the first row (1-Sep). If all the 5 numbers are present in that row, put the date 1-Sep in cell AE1. If not, go to the second row. Do this till the last row. Do the same task for the next range 10 11 42 45 63 The answer is AE1 will have 2-Sep as all the five number were present in the second row and AF1 will have 5-Sep again the same 5 numbers were present in 5th row. AE2 will have 3-Sep as 10 11 42 45 63 were present in the 3rd row. I have data will march end and doing this manully will be a very tedious task. Can this be automated using a formula or VBA? Maxi |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
searching between dates | Excel Worksheet Functions | |||
Searching, matching then searching another list based on the match | Excel Discussion (Misc queries) | |||
Searching on Dates | Excel Worksheet Functions | |||
Searching For Files with Dates | Excel Programming | |||
searching for a range of dates | Excel Programming |