hiding redundant values from multiple sets along with adjacent values

Hello Excel Forum Folks,

I am working on creating a spreadsheet that can be updated by those unfamiliar to excel. I have a master list on one sheet and three separate lists for business, individual, and general. Each list has three columns giving name, address and postal code. There are numerous repeats on these lists and I wanted to hide any duplicates while keeping my cells aligned. So far I have been able to highlight any duplicates, but was interested in some function that would save at least one duplicate while hiding any additional ones.

Any ideas?

Avery

Yeah that was a big help. I found that after I made my values into a table I was able to have rowed cells grouped together.