Hi Experts,
Looking for a help, as I have a requirement to find out the 3 largest value from a table which is attached.
My selection is dynamic which are the “Month” and “Category”
I have put a “large” formula combined with “Iferror” which was working fine but stuck in two cases.
• Duplicate values ( which is to come as the next position)
• Don’t know how to retrieve the name matching to the resulted value, which is to shown in the adjacent column.
I have put the desired result also. I have highlighted the duplicate values in each month for your easy identification.
I am using Office 365.
Thanks in advance for the help.
Bookmarks