Hi.
I have a table containing Names in col A, TRUE/FALSE in col C and names of groups in col D.
Names in col A can appear multiple times, once for each group they are listed as having in col D.
My list is nearly 20,000 names long and I need to create a list of unique names that have FALSE in col C and then list all of the groups they belong to in col D. (The aim is to list all of the groups each name has access to but no longer require ("FALSE") so that I can arrange to have them removed from those groups.
I've attempted this with a couple of different formula but can't get it to work.
I'm thinking that the list of groups will need to be displayed horizontally since the Unique list of names is around 2,500 rows and the most groups anyone will have is less than 20.
I've attached a small sample of this and would appreciate any help in getting the data I'm looking for.
Thanks.
Bookmarks