karmaimages
Board Regular
- Joined
- Oct 1, 2009
- Messages
- 112
- Office Version
- 365
- Platform
- Windows
Hi
I have a list of names in Col N and which I'm filtering on a dashboard to the current year things have been listed to their names using the following formula:
=SORT(UNIQUE(FILTER('Data For Attribution'!N:N,('Data For Attribution'!R:R=Dashboard!B2))))
B2 Contains a drop down of dates which updates all sheets when the user changes the year.
However, I only need to display the Top 10 in the unique list, is there a better way without Pivots to do this?
Many Thanks
I have a list of names in Col N and which I'm filtering on a dashboard to the current year things have been listed to their names using the following formula:
=SORT(UNIQUE(FILTER('Data For Attribution'!N:N,('Data For Attribution'!R:R=Dashboard!B2))))
B2 Contains a drop down of dates which updates all sheets when the user changes the year.
However, I only need to display the Top 10 in the unique list, is there a better way without Pivots to do this?
Many Thanks