Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-13-2018, 11:25 PM
Marcia's Avatar
Marcia Marcia is offline Extracting unique values from a list and sorted alphabetically Windows 7 32bit Extracting unique values from a list and sorted alphabetically Office 2007
Expert
Extracting unique values from a list and sorted alphabetically
 
Join Date: May 2018
Location: Philippines
Posts: 554
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
Default

[quote=p45cal;134383]Formulas like that can get difficult to maintain.
Use a pivot table and slicers/timelines. See attached; a very basic pivot table.[/




Thank you. I will explore the Pivot table using the slicers, although I found a formula that returned sorted lists based on conditions. It's quite long and a bit frightening.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Extracting unique values from a list and sorted alphabetically Loop through cells and return only unique values trevorc Excel Programming 4 10-11-2018 03:49 PM
Extracting unique values from a list and sorted alphabetically Create a unique list of values that match a criteria, sorted in order of another criteria BradRichardson Excel 2 01-03-2017 12:25 AM
Extracting unique values from a list and sorted alphabetically Count unique values that match 2 or more criteria caeiro01 Excel 1 10-25-2015 02:34 AM
Extracting unique values from a list and sorted alphabetically How to use mail merge to create a list sorted by category in Word elisa2013 Mail Merge 5 03-14-2014 02:35 AM
Creating a list and sorting alphabetically. irvsax Word 4 09-04-2013 11:47 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:06 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft