Finding duplicate values in a column

K

Kyleanne

Hi,

I have a huge spreadsheet containing stock items and their location numbers,
among other things. Some of these location numbers are the same as each
other, and I need to find a way to look up and display all rows which contain
duplicate location numbers. I only want these rows to be displayed. I have
searched through the functions and formulas, but I cannot find a way to do
it. Can anybody help me? This would save hours and hours of manually
searching through the list and highlighting duplicate values.

Regards,

Kyleanne
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Finding Duplicate Rows & Highlighting them 6
Finding the proper style field and the numbered paragraph value within the style 0
Highlighting duplicates on different sheets 2
Find partial text and retrun value in corresponding column 3
Separating Duplicates?? 2
Problem with formula for finding last greater than/less than or equal to value 2
Duplication 2
Finding and Isolating Duplicates 4

Top