Thread: First, Last occurance of date in column
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Rosenfeld[_2_] Ron Rosenfeld[_2_] is offline
external usenet poster
  
Posts: 1,045
Default First, Last occurance of date in column
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.
Reply With QuoteReply With Quote