Thread: Top 3 items? (INDEX,MODE,MATCH,COUNTIF)
View Single Post
 
Old 01-22-2021, 07:14 AM
p45cal's Avatar
p45cal p45cal is offline Windows 10 Office 2019
Expert
  
Join Date: Apr 2014
Posts: 956
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default
Pivot table at cell F8 of the Main sheet.
The Names column is

1. filtered by Top Ten (top 3 in this case) based on the Count of Status
2. Sorted descending based on ther Count of Status.
Attached Files
File Type: xlsx msofficeforums46375MsForums.xlsx (18.0 KB, 7 views)
Reply With Quote