sorting
 

Hi
I have lots of date in two column. Like A & B. In column B some nos are
repeat man times. I want to sort my table. In column B, if nos are repeat
display in one place.
Example
A B
a 11
b 11
C 12
D 13
E 12
I want to sort in this type
A B
a 11
C 12
D 13

Thanks
RKS

sorting
 

One way ..

Assuming data in cols A and B, from row1 down

Put in C1:
=IF(B1="","",IF(COUNTIF($B$1:B1,B1)1,"",ROW()))

Put in D1:
=IF(ROW()COUNT($C:$C),"",INDEX(A:A,SMALL($C:$C,RO W())))
Copy D1 to E1

Select C1:E1, copy down as far as required.
Hide away col C. Cols D and E returns the required results.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"RKS" wrote:
Hi
I have lots of date in two column. Like A & B. In column B some nos are
repeat man times. I want to sort my table. In column B, if nos are repeat
display in one place.
Example
A B
a 11
b 11
C 12
D 13
E 12
I want to sort in this type
A B
a 11
C 12
D 13

Thanks
RKS