Filtering Question

[gibson2503]

I have a worksheet with several columns, one of which is Employee Name. The rest of the columns have various different data for that employee. Some employee names appear on only one row. However most employee names appear on over 20 rows. How can I temporarily filter the worksheet to show me only the first row of each employee name, all at one time?

[regulus1086]

Hey gibson, would you be able to attach a copy of the spreadsheet? I think i have an answer for you but wanted to see the product to make sure i give you accurate info.

[gibson2503]

Regulus,

Here is a sample of what I am working with. I had to delete the data from the first column because it had SSN's, and I changed the names (rules of my organization when sending things to the outside). This is just a sampling of 3 people. My original spreadsheet contains almost 1000 people, most having over 20 rows each. I want to be able to make the whole spreadsheet show me only the first row of each name, then switch it back to the full list when I am ready.

[gibson2503]

Just checking for replies before I head out to lunch.

[FDibbins]

I added this, copied down, to a helper column. You can then filter the table, based on the helper, using no blanks...
=IF(COUNTIF($B$2:B2,B2)>1,"",B2)

[gibson2503]

I added this, copied down, to a helper column. You can then filter the table, based on the helper, using no blanks...
=IF(COUNTIF($B$2:B2,B2)>1,"",B2)

Worked like a charm. Thanks.

[FDibbins]

Happy to help. If this answered your question, please take a moment to mark the thread as "solved" - it helps keep things neat and tidy lol, and consider adding the reputation to those that helped (see points 2 & 3 below)