Find next / subsequent date in list

ateleoh

Hi, I am stumped.  I am trying to figure out how to figure out the second (and third) date for each unique entry in the Provider/Resource column.  I am using this formula to find the first date: 

=IF(Date@row = MIN(COLLECT(Date:Date, [Provider/Resource]:[Provider/Resource], =[Provider/Resource]@row)), Date@row, 0)

Paul Newcome

Swap your MIN out for a SMALL.

 

=SMALL(range, n)

 

where n represents the nth lowest number within the range. 

 

So

 

=SMALL(range, 2)

 

would provide you with the second smallest number, or in this case, the second date.

 

(LARGE works the same way for MAX)