Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula Question
{=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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula Question
Please excuse the misrepresentation of the array and range. I've corrected it.
"Shu of AZ" wrote: {=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"))),""),COLUM N()-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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula question | Excel Worksheet Functions | |||
Formula question | Excel Discussion (Misc queries) | |||
Need help with a formula question | Excel Discussion (Misc queries) | |||
Newbie Question - Subtraction Formula Question | Excel Discussion (Misc queries) | |||
Formula question | Excel Worksheet Functions |