Thread: First, Last occurance of date in column
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Don Guillett[_2_] Don Guillett[_2_] is offline
external usenet poster
  
Posts: 1,522
Default First, Last occurance of date in column
On Nov 3, 3:19*pm, Ron Rosenfeld wrote:
On Thu, 3 Nov 2011 10:52:30 -0700 (PDT), Don Guillett wrote:
=MATCH(e1,D:D,1)
for last

With an unsorted list I get #N/A for this one.

missed the sorting.
Reply With QuoteReply With Quote