Not very experienced with excel, so any help here would be greatly appreciated.

Basically, I have a huge list of all items found in our hospital and what locations these items can be found in. I am trying to create another spreadsheet that displays all duplicate items (items that can be found in more than 1 location). This new spreadsheet needs to be derived from a list of items that I specify from the original spreadsheet. I can filter them all individually to determine the duplicates, but this is time consuming considering that I am dealing with over 1700 items. Is there any way I can select a range of item numbers and have excel pull up all of the other rows that contain those same item numbers?

It's confusing to explain, so let me know if I can provide any more specifics.

Thanks in advance