View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Gadget Gadget is offline
external usenet poster
 
Posts: 1
Default 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".