Hide Rows If Cell Value in Column A is Repeat Information

[samsilverman]

I have a Summary Sheet that pulls data from various cells in other worksheets with the Indirect Function. But some of that info placed in the Summary Sheet is necessary repeated (would take too long to explain). What I need is explained in the title, but I need the first instance to remain. For example:

Cell A26 = Room 1
Cell A27 = Room 2
Cell A28 = Room 3
Cell A29 = Room 4
Cell A30 = Room 2

In this example I would need Row 30 hidden because Cell A27 contains the same value. This would need to occur for any subsequent row that contains repeat values that have already appeared in the A Column. The catch is I need this to NOT happen for the first 2 rows of each page in the Summary Sheet as they contain column headers.

 

[HalfAce]

Hi,
Using your posted range & values, you can do this with Advanced Filter.
Highlight the range (example A26:A30) and from the menu, choose Data > Filter > Advanced Filter (and hit OK).
Then just tick the 'Unique records only' checkbox.

Mind you, this is how you can do it in a caveman version of Excel, so I'm not sure where to find it in newer versions using the ribbon and such, but the idea should be the same.

Does that help at all?

 

[samsilverman]

Wow, that was easy. Thanks a bunch!!

 

[HalfAce]

Most welcome. Glad it helped.