{=SMALL(IF(FREQUENCY(SMALL($E$6:$F$11,ROW(INDIRECT ("1:6"))),SMALL($E$6:$F$11,ROW(INDIRECT("1:6")))) 0,SMALL($E$6:$F$11,ROW(INDIRECT("1:6"))),""),COLUM N()-COLUMN($AC$60)+1)}

The above formula displays 6 cell's values and eliminates any duplicates.

3 7 8
4 7 8

The result is 3 4 7 8

If I wanted to display another cell in addition to the 6 described, ( G22 ),
how would I say it in this formula. When I try, (($E$:$F11,$G22),ROW,,,
) I always get too many arguments error. Thanks in advance.