I
ignus99
Sorry for the newb question. but is there a way to have on column the
alphebetised version of another column? thanks in advance
alphebetised version of another column? thanks in advance
D
Domenic
Assuming that A1:A10 contains your data, try the following...
B1, copied down:
=COUNTIF($A$1:$A$10,"<"&A1)+1
C1, copied down:
=INDEX($A$1:$A$10,MATCH(ROW()-ROW($C$1)+1,$B$1:$B$10,0))
Hope this helps!
B1, copied down:
=COUNTIF($A$1:$A$10,"<"&A1)+1
C1, copied down:
=INDEX($A$1:$A$10,MATCH(ROW()-ROW($C$1)+1,$B$1:$B$10,0))
Hope this helps!
K
Ken Wright
No apologies needed regardless of the level of the question, but you may
have to clarify exactly what you mean, as personally I'm a tad confused to
be honest.
have to clarify exactly what you mean, as personally I'm a tad confused to
be honest.
B
Bob Phillips
Nice Domenic, but seems to throw a wobbly with repeated data
Bob
Bob
D
Domenic
Actually, with the data containing text values, I hadn't thought about
repeated data. In this case, the formula for B1 could be changed to the
following...
=(COUNTIF($A$1:$A$10,"<"&A1)+1)+(COUNTIF($A$1:A1,A1)-1)
Thanks for catching that Bob! Much appreciated!
repeated data. In this case, the formula for B1 could be changed to the
following...
=(COUNTIF($A$1:$A$10,"<"&A1)+1)+(COUNTIF($A$1:A1,A1)-1)
Thanks for catching that Bob! Much appreciated!
B
Bob Phillips
I always like a nice solution .
Regards
Bob
.Regards
Bob
Domenic said:Actually, with the data containing text values, I hadn't thought about
repeated data. In this case, the formula for B1 could be changed to the
following...
=(COUNTIF($A$1:$A$10,"<"&A1)+1)+(COUNTIF($A$1:A1,A1)-1)
Thanks for catching that Bob! Much appreciated!