This for my Brother not for me. He just expects me to know the answer (SEE THE IMPOSSIBLE what brother really wants)
I have a spreadsheet I export a second column. This is not the problem.. here is the problem
column 1 is master column it has all the names I have
example (400 names)
Column 2 is imported names.
example (320 names)
ok here is the problem
I want colum 3 to show what is missing in column 2 compaired to column 1
example (80 people missing)
I've been told you can do it with Conditional Formatting. I have no idea how to do it
ok here comes the extra credit (THE IMPOSSIBLE)
I want column 2 to actually show the names that are missing by moving the cell down putting in the name and highlighting it.
I have a spreadsheet I export a second column. This is not the problem.. here is the problem
column 1 is master column it has all the names I have
example (400 names)
Column 2 is imported names.
example (320 names)
ok here is the problem
I want colum 3 to show what is missing in column 2 compaired to column 1
example (80 people missing)
I've been told you can do it with Conditional Formatting. I have no idea how to do it
ok here comes the extra credit (THE IMPOSSIBLE)
I want column 2 to actually show the names that are missing by moving the cell down putting in the name and highlighting it.