Thread: [Solved] Extracting unique values from a list and sorted alphabetically
View Single Post
 
Old 10-13-2018, 12:18 PM
p45cal's Avatar
p45cal p45cal is offline Windows 10 Office 2016
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
Formulas like that can get difficult to maintain.
Use a pivot table and slicers/timelines. See attached; a very basic pivot table.
Attached Files
File Type: xlsx msofficeforums40610School Form 1B.xlsx (22.6 KB, 12 views)
Reply With Quote