DashboardNovice
Member
In the attached file, I have multiple pay periods listed, however each pay period appears more than once. I am trying to return the 1st smallest, 2nd smallest, etc.
When I use the SMALL function, the 2nd and 3rd values, etc. are the same as the first value since these pay periods appear more than once.
I am trying to find a way to list the smallest pay period first, followed by the one that is truly the 2nd smallest, then the 3rd smallest, etc.
Cells H6:H10 contain what the desired results would be.
When I use the SMALL function, the 2nd and 3rd values, etc. are the same as the first value since these pay periods appear more than once.
I am trying to find a way to list the smallest pay period first, followed by the one that is truly the 2nd smallest, then the 3rd smallest, etc.
Cells H6:H10 contain what the desired results would be.
Attachments

9 KB Views: 1