Sorting

H

harvindersingh1

I have certain data in a column A(say). Now, in column A there ar
certain entries that are repeating.I want that the entries that ar
repeating two times should be displayed in column B, the items that ar
repeating three times are displayed in column C and so on.

Kindly help....

With regards
Harvinder Sing
 
S

starguy

i supposed that your data is in the range of A1:A50
in col B enter this formula
=if(countif($A$1:$A$50,A1)=2,A1,"") and copy this formula down to B50
in col C enter this formula
=if(countif($A$1:$A$50,A1)=3,A1,"") and copy this formula down to C50
 
B

Bryan Hessey

For data starting at A2, in B2 put the formula:


=IF($A2=$A1,"",IF($A2<>INDIRECT("$A"&ROW()+COLUMN()-2),"",INDIRECT("$A"&ROW()+COLUMN()-2)))

and formula drag this to the right as far as needed, then down as far
as needed (ie, bulk-drag B2 to (say) F2) will show up to 5 repeats,
display on the first line only.

Hope this helps

--
 
B

Bryan Hessey

For data starting at A2, in B2 put the formula:


=IF($A2=$A1,"",IF($A2<>INDIRECT("$A"&ROW()+COLUMN()-2),"",INDIRECT("$A"&ROW()+COLUMN()-2)))

and formula drag this to the right as far as needed, then down as far
as needed (ie, bulk-drag B2 to (say) F2) will show up to 5 repeats,
display on the first line only.

Hope this helps

--
 
Top