Hello there, Excel Forum!
I have been thinking about this formula for a while now,
I still can't wrap my head around it and find a solution.
I am seeking any solutions from Excel Forum.
It would be a big help if anyone can help me!
Formula function: Rank Data Based On Their Dates Without Ties and sort according to rank
The data source is live and changing everyday, is it possible to let the rank cell range to be flexible?
For example:
1.To rank dates based on dates without ties
Container No Dates Rank
IAAU2684503 03/02/2021 5
IAAU2686661 03/02/2021 4
IAAU2715672 02/02/2021 3
IAAU2716977 01/02/2021 1
IAAU2722162 03/02/2021 6
IAAU2732920 01/02/2021 2
IAAU2764975 04/02/2021 7
2. Sort according to rank
Container No Dates Rank
IAAU2716977 01/02/2021 1
IAAU2732920 01/02/2021 2
IAAU2715672 02/02/2021 3
IAAU2686661 03/02/2021 4
IAAU2684503 03/02/2021 5
IAAU2722162 03/02/2021 6
IAAU2764975 04/02/2021 7
Thank you for your attention!
Bookmarks