Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting Sorting Sorting | Excel Discussion (Misc queries) | |||
Sorting | New Users to Excel | |||
Sorting Data in ascending order | Excel Discussion (Misc queries) | |||
sorting number in ascending order | Excel Discussion (Misc queries) | |||
SORTING question | New Users to Excel |