Home |
Search |
Today's Posts |
#1
|
|||
|
|||
unique alpha's in order
Hi i have the following which gives me unique alpha's in order but when it has produced all possible entry's it diplays an error. =INDEX($A$1:$A$6,MATCH(SMALL(IF(($A$1:$A$6<"")*(C OUNTIF(OFFSET($A$1,0,0,ROW($A$1:$A$6)-ROW($A$1)+1),$A$1:$A$6)=1),COUNTIF($A$1:$A$6,"<"&$ A$1:$A$6)),ROWS($B$1:B1)),COUNTIF($A$1:$A$6,"<"&$A $1:$A$6),0)) I have tried using the below but it didnt work and it made the cell very large =if(iserror(formula)=true,"",formula Can anyone help? -- ceemo ------------------------------------------------------------------------ ceemo's Profile: http://www.excelforum.com/member.php...o&userid=10650 View this thread: http://www.excelforum.com/showthread...hreadid=396150 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
count unique with conditions | Excel Worksheet Functions | |||
How to change Series Order in a Combination Chart? | Excel Discussion (Misc queries) | |||
Maintaining a default worksheet order | Excel Discussion (Misc queries) | |||
Data association | Excel Worksheet Functions | |||
Count unique alpha numeric "characters" in a common cell | Excel Worksheet Functions |