Extracting unique values from a list and sorted alphabetically

		Microsoft Office Forums > Microsoft Excel > Excel
Extracting unique values from a list and sorted alphabetically

FAQ

Thread Tools

Display Modes

10-12-2018, 12:39 AM

Marcia

Windows 7 32bit Extracting unique values from a list and sorted alphabetically

Office 2007

Expert

Join Date: May 2018

Location: Philippines

Posts: 551

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

School Form 1B.xlsm (50.9 KB, 14 views)

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 12:32 PM.