Excel table

Question

I am using an Excel table with Listed name showing say five times. I would like to show only one name line. How do I hide the remaining table

Answer 1

To hide duplicate entries in an Excel table and show only one instance of a name, you can use the filtering feature. Here’s how you can do it:

1. Select the Table: Click anywhere in your Excel table.
2. Apply Filter: Go to the Data tab on the Ribbon and click on Filter. This will add filter dropdowns to each column header.
3. Filter Duplicates: Click the dropdown arrow in the column that contains the names. Uncheck the duplicates, leaving only the unique name checked. This will hide the remaining duplicates in the table.
4. Clear Filter: If you wish to see all names again, you can clear the filter by clicking the filter dropdown and selecting Clear Filter.

Alternatively, if you want to use a formula to create a new table with unique names, you can use the UNIQUE function (available in Excel 365 and Excel 2021):

=UNIQUE(A1:A10)

This will return a list of unique names from the specified range.

If you are using VBA, you can also hide rows based on your criteria programmatically.

---

References:

• Hide sheets and use the xlVeryHidden constant in a macro