enter image description hereI have peoples names in the columns under each name is rows with the week and then a number under each column name, I want to find a formula that can auto calculate the top 3 names of the values for a specific week I select, any ideas woukd be greatly appreciated.
I’ve used index match and large functions to gain the top 3 names automatically however the step I cannot workout is getting the top 3 names by the date
As per above, ive tried filter but nothing, the furthest ive got is using the index, match and large functions as mentioned in my question.
Joel Hide is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.