Sorting
 

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

Kindly help....

With regards
Harvinder Singh


--
harvindersingh1
------------------------------------------------------------------------
harvindersingh1's Profile: http://www.excelforum.com/member.php...o&userid=31725
View this thread: http://www.excelforum.com/showthread...hreadid=533628

Sorting
 

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

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

Kindly help....

With regards
Harvinder Singh


--
starguy
------------------------------------------------------------------------
starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434
View this thread: http://www.excelforum.com/showthread...hreadid=533628

Sorting
 

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

--

starguy Wrote:
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


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=533628

Sorting
 

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

--

starguy Wrote:
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


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=533628