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