With much internet searching I found and use with my requirements a formula for removing BLANKS and DUPLICATES
=IFERROR(LOOKUP(2, 1/((COUNTIF($BZ$16:BZ16, $BS$17:$BS$27)=0)*($BS$17:$BS$27<>"")),$BS$17:$BS$27),"")
and another formula to ALPHABETIZE this list
=IFERROR(INDEX($BZ$17:$BZ$27, MATCH(SMALL(IF(COUNTIF($CG$16:CG16, $BZ$17:$BZ$27)=0, COUNTIF($BZ$17:$BZ$27, "<"&$BZ$17:$BZ$27), ""), 1), COUNTIF($BZ$17:$BZ$27, "<"&$BZ$17:$BZ$27), 0)),"")
Is there a way to combine these to preform the same NO BLANKS, NO DUPLICTES, And ALPHABETIZE in one process?
I've include an image, the main field that holds the primary data is in cells BS17:BS27, the no blanks and no duplicates is cells BZ17:BZ27, the alphabetized list is in cells CG17:CG27 and is based on cells BZ17:BZ27.
Can I accomplish this all in one step
=IFERROR(LOOKUP(2, 1/((COUNTIF($BZ$16:BZ16, $BS$17:$BS$27)=0)*($BS$17:$BS$27<>"")),$BS$17:$BS$27),"")
and another formula to ALPHABETIZE this list
=IFERROR(INDEX($BZ$17:$BZ$27, MATCH(SMALL(IF(COUNTIF($CG$16:CG16, $BZ$17:$BZ$27)=0, COUNTIF($BZ$17:$BZ$27, "<"&$BZ$17:$BZ$27), ""), 1), COUNTIF($BZ$17:$BZ$27, "<"&$BZ$17:$BZ$27), 0)),"")
Is there a way to combine these to preform the same NO BLANKS, NO DUPLICTES, And ALPHABETIZE in one process?
I've include an image, the main field that holds the primary data is in cells BS17:BS27, the no blanks and no duplicates is cells BZ17:BZ27, the alphabetized list is in cells CG17:CG27 and is based on cells BZ17:BZ27.
Can I accomplish this all in one step