L
Learning Excel
This should be interesting.
I have a list of names, about 300, in a worksheet that I use for a dropdown
list
in all other sheets ( call Jan, Feb, March...).
As I get a call from each person every month I dropdown my list and select
that
name from my list and write " called ".
Each month I have to find out who did not call based on checking who called
of course. Is there a way CF,VLOOKUP,FORMULA to highligth, color or bold the
people that did not call for that month? ( either in the list of names
"thelist" or
in different place where I can see who did not call on each monthly basis.
I have a list of names, about 300, in a worksheet that I use for a dropdown
list
in all other sheets ( call Jan, Feb, March...).
As I get a call from each person every month I dropdown my list and select
that
name from my list and write " called ".
Each month I have to find out who did not call based on checking who called
of course. Is there a way CF,VLOOKUP,FORMULA to highligth, color or bold the
people that did not call for that month? ( either in the list of names
"thelist" or
in different place where I can see who did not call on each monthly basis.