Extracting Unique Items from a List w/conditional formatting?

KaiRose

New Member
Joined
Aug 24, 2018
Messages
2
Greetings!

The project: I have a large set of tables in one tab that is acting as a tracking system for team participation. When a member doesn't show up, I'd like to ask the captains to indicate the missing participant with either a color or italicizing/strikeout.

I would like a list to automatically populate on the next tab, when the captain changes the cell. This way, we have an easy list to view for participants that are consistently not showing up.

For example
f4bDv9
(see attached image): Jane, Susan, and Jaime don't show up. The captain(s) go into our excel and mark them absent in some formatting change (bolding, italicizing, etc.). I'd like tab two to then list the actual names "Jane," "Susan," and "Jaime" for the administrators to reference.

Any ideas? I've been trying to work with something like this, but just unsure of how to call out the formatting:
{=INDEX(list,MATCH(0,COUNTIF(uniques,list),0))}


Thank you!
 

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.

Forum statistics

Threads
1,223,228
Messages
6,170,871
Members
452,363
Latest member
merico17

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top