Sequence Number To Reference?

[shellp]

Hello,

I am using Excel 365 and I have a spill formula with the results being used in a dropdown list:

=Sort(Unique(T_Total[Report Date]),1)

What I want to do is create a sequence number so that I can refer to the nth value in the drop down that will change dynamically. Is this possible or am I approaching this the wrong way? All assistance greatly appreciated.

Shelley

 

[saboh12617]

Hello,

It is possible using INDEX on your sorted list, or SMALL/LARGE on your unsorted list.

Example : 5-th smallest value is

=INDEX(Sort(Unique(T_Total[Report Date]),1), 5)

Or

=SMALL(Unique(T_Total[Report Date]), 5)

 

[shellp]

Thank you so much for your response! This totally worked!!

 

[saboh12617]

Glad to help, have a good day.