Formula Question

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Shu of AZ - 29 Mar 2008 23:23 GMT

{=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"))),""),COLUMN()-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.

Reply to this Message

Shu of AZ - 30 Mar 2008 17:25 GMT

Please excuse the misrepresentation of the array and range. I've corrected it.

> {=SMALL(IF(FREQUENCY(SMALL($E$6:$F$10,ROW(INDIRECT("1:6"))),SMALL($E$6:$F$10,ROW(INDIRECT("1:6"))))>0,SMALL($E$6:$F$10,ROW(INDIRECT("1:6"))),""),COLUMN()-COLUMN($AC$60)+1)}
>
> The above formula displays 6 cell's values and eliminates any duplicates.

> E F
> 6/7: 3 7
> 8/9: 4 7
> 10/11: 8 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$:$F10,$G22),ROW,,,,,,and increase the value of ("1:6") to ("1:7")I always get too many arguments error. Thanks in advance.

Reply to this Message