I have a small spreadsheet as follows: The data is 2 groups of records that have similarity like the Name mainly
The first type of record does not have anything for Unit. And the second type does. I want to have a macro that will only display only the Name person who has from both groups.
So following him would be someone with records only with the unit blank, we don't want that. It is only possible that the second type is in conjunction with the first type as in our case here.
Name Ind Class Unit
The first type of record does not have anything for Unit. And the second type does. I want to have a macro that will only display only the Name person who has from both groups.
So following him would be someone with records only with the unit blank, we don't want that. It is only possible that the second type is in conjunction with the first type as in our case here.
Name Ind Class Unit
Bill Clarke | 1 | Pro | ||||
Bill Clarke | 1 | SUP | ||||
Bill Clarke | 1 | SUPCON | ||||
Bill Clarke | SUPCON2 | Unit#1 | ||||
Bill Clarke | PRO | Unit#2 | ||||
Bill Clarke | SUPCON | Unit#3 |