thewheatbread
New Member
- Joined
- Oct 6, 2022
- Messages
- 6
- Office Version
- 365
- 2021
- Platform
- Windows
- MacOS
I'm creating a dashboard on a separate sheet with the following dataset. I need the top 5 Totals and their corresponding projects. I've been using
and then changing the row and LARGE reference. It worked for the first two but then when I get to the duplicated Total number it freaks out. It needs to run vertical.
(sorry I can’t run XL2BB on my computer.)
Excel Formula:
=INDEX(Sheet1!$A$2:$A$9,LARGE(IF(LARGE(Sheet1!$L$2:$L$9,1)=Sheet1!$L$2:$L$9,ROW(Sheet1!$L$2:$L$9)+1),1))
(sorry I can’t run XL2BB on my computer.)