Find duplicate data within a column.

Hi there...

I have a single column of data and I wish to highlight all the information
in the cells where the data is matched with another cell in the column. Not
sure if that explains it very well, but basically in the example below I
want to indentify the rows that contain the two exact same numbers.

I am trying to find unique pairs of data.


E.g in the example below I want to be able to identify the two instances of
424543.

524543
424543
245242
453334
424543


I know I can sort but the dataset is too large to do this manually...i.e
there are lots of instances...


any help would be very much appreciated.

Thanks
Steve

Steve, have a look here http://cpearson.com/excel/duplicat.htm

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Steve Franklin" <[email protected]> wrote in message
news:[email protected]...
> Hi there...
>
> I have a single column of data and I wish to highlight all the information
> in the cells where the data is matched with another cell in the column.
Not
> sure if that explains it very well, but basically in the example below I
> want to indentify the rows that contain the two exact same numbers.
>
> I am trying to find unique pairs of data.
>
>
> E.g in the example below I want to be able to identify the two instances
of
> 424543.
>
> 524543
> 424543
> 245242
> 453334
> 424543
>
>
> I know I can sort but the dataset is too large to do this manually...i.e
> there are lots of instances...
>
>
> any help would be very much appreciated.
>
> Thanks
> Steve
>
>

Excellent...thanks so much...


Love the community spirit of newsgroups...




"Paul B" <[email protected]> wrote in message
news:[email protected]...
> Steve, have a look here http://cpearson.com/excel/duplicat.htm
>
> --
> Paul B
> Always backup your data before trying something new
> Please post any response to the newsgroups so others can benefit from it
> Feedback on answers is always appreciated!
> Using Excel 2002 & 2003
>
> "Steve Franklin" <[email protected]> wrote in message
> news:[email protected]...
>> Hi there...
>>
>> I have a single column of data and I wish to highlight all the
>> information
>> in the cells where the data is matched with another cell in the column.
> Not
>> sure if that explains it very well, but basically in the example below I
>> want to indentify the rows that contain the two exact same numbers.
>>
>> I am trying to find unique pairs of data.
>>
>>
>> E.g in the example below I want to be able to identify the two instances
> of
>> 424543.
>>
>> 524543
>> 424543
>> 245242
>> 453334
>> 424543
>>
>>
>> I know I can sort but the dataset is too large to do this manually...i.e
>> there are lots of instances...
>>
>>
>> any help would be very much appreciated.
>>
>> Thanks
>> Steve
>>
>>
>
>