|
|
#1
10-12-2018, 12:39 AM
|
||||
|
||||
Extracting unique values from a list and sorted alphabetically
I had been trying to tweak this array formula to sort what it extracted from a list in ascending order but to no avail. Please help.
=IFERROR(INDEX(NAMES,MATCH(0,IF(GRADES=$X$8,IF(SEC TIONS=$AC$8,COUNTIF($B$12:$B12,NAMES),"")),0)),"") Or this: =IFERROR(INDEX(NAMES,SMALL(IF(GRADES=$X$8,IF(SECTI ONS=$AC$8,IF(SEX_1="M",IF(DATEENROLLED<=$X$6,ROW(N AMES)-ROW($B$2)+1)))),ROWS($B$2:$B3))),"") 
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Loop through cells and return only unique values
|
trevorc | Excel Programming | 4 | 10-11-2018 03:49 PM |
|
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 |
|
Count unique values that match 2 or more criteria
|
caeiro01 | Excel | 1 | 10-25-2015 02:34 AM |
|
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 |
Windows 7 32bit 
Office 2007
Threaded Mode