View Single Post
 
Old 05-09-2017, 11:37 AM
jpreeshl jpreeshl is offline Windows 10 Office 2007
Novice
 
Join Date: Jan 2016
Posts: 8
jpreeshl is on a distinguished road
Default

My current formula already returns a blank in the row if a names doesn't show up.
Column A formulas {=IFERROR(INDEX(names, SMALL(IF("Y"=Alphabetical!$I$2:$I$185, ROW($E$3:$E$186)-MIN(ROW($E$3:$E$186))+1, ""), ROW(A31))),"")}

Column B formulas {=IFERROR(INDEX(names, SMALL(IF("YC"=Alphabetical!$I$2:$I$185, ROW($E$3:$E$186)-MIN(ROW($E$3:$E$186))+1, ""), ROW(E7))),"")}
Reply With Quote