Thread: [Solved] Extracting unique values from a list and sorted alphabetically
View Single Post
 
Old 10-12-2018, 12:39 AM
Marcia's Avatar
Marcia Marcia is offline Windows 7 32bit Office 2007
Expert
  
Join Date: May 2018
Location: Philippines
Posts: 553
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
Default 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))),"")
Attached Files
File Type: xlsm School Form 1B.xlsm (50.9 KB, 14 views)
Reply With Quote