List of unique texts and numbers
v,
You can do this with three columns of formulas.
In cell B1, enter the formula
=IF(COUNTIF($A$1:A1,A1)=1,A1,"")
In cell C1, enter the formula
=IF(B1<"",SUMPRODUCT(($B$1:$B$1000<"")*($B$1:$B$ 1000<B1)*1)+1,"")
In cell D1, enter the formula
=IF(NOT(ISERROR(MATCH(ROW(),C:C,FALSE))),INDEX(B:B ,MATCH(ROW(),C:C,FALSE)),"")
And copy all three cells down to match your list in column A
HTH,
Bernie
MS Excel MVP
"vsoler" wrote in message
oups.com...
In A1:A1000 I have cells with text and blank cells. Texts are often
repeated.
I would like in B1:B1000 all texts appearing at the top, without any
duplicates, blanl at the bottom.
What formula should I use in B1:B1000 ?
Thank you
A B
1 ABC ABC
2 XYZ XYZ
3 GHT GHT
4 GHT
5
Is it possible that B1:B1000 appear already sorted?
|