| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Define a range by searching for first and last?
I need a formula that searches a column of log file dates for the first and
last entry in a month and returns the address of the first and last. Example: A1 2-30-09 A2 2-31-09 A3 2-31-09 A4 3-3-09 A5 3-4-09 A6 3-26-09 A7 3-27-09 A8 4-2-09 If I asked it for March, it should return "A4:A7" or "A4", "A7". |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Name to define a chart range | Excel Discussion (Misc queries) | |||
| Define a range | Excel Discussion (Misc queries) | |||
| how to define range names | New Users to Excel | |||
| Looking for code to define a range | Excel Discussion (Misc queries) | |||
| Define a range based on another named range | Excel Worksheet Functions | |||
Threaded Mode
