sulbaran
New Member
- Joined
- May 26, 2010
- Messages
- 8
Hello to all
I need to compare names in two columns, task looks simple but I can't figure out using conditional formating or some solutions around internet? I have one Column ( said A) with names on completed procedures and another column ( said B ) with names on procedures charged, my goal is to find out what names on column A don't show in column B and if possible listed in a another column ( said C )
In my case will be valid for another report that shows instead of name, have procedures names...
As in the below example: the name " Calling John is on Column A but not on the Column B and I'll like that name in column B and will like that in another column, ( said C ), also the names Cook, Oscar and Salders, Paul are in column B but not on A and I'll like that in another column ( said D )
The report include thousands of rows.
Thanks in advance for you help ...
Sulbaran
<TBODY>
</TBODY>
I need to compare names in two columns, task looks simple but I can't figure out using conditional formating or some solutions around internet? I have one Column ( said A) with names on completed procedures and another column ( said B ) with names on procedures charged, my goal is to find out what names on column A don't show in column B and if possible listed in a another column ( said C )
In my case will be valid for another report that shows instead of name, have procedures names...
As in the below example: the name " Calling John is on Column A but not on the Column B and I'll like that name in column B and will like that in another column, ( said C ), also the names Cook, Oscar and Salders, Paul are in column B but not on A and I'll like that in another column ( said D )
The report include thousands of rows.
Thanks in advance for you help ...
Sulbaran
Names Completed | Names Charged | ||
<TBODY> </TBODY> |
<TBODY> </TBODY> | ||
<TBODY> </TBODY> |
<TBODY> </TBODY> | ||
<TBODY> </TBODY> |
<TBODY> </TBODY> | ||
<TBODY> </TBODY> |
<TBODY> </TBODY> | ||
<TBODY> </TBODY> |
<TBODY> </TBODY> | ||
<TBODY> </TBODY> |
<TBODY> </TBODY> | ||
<TBODY> </TBODY> |
<TBODY> </TBODY> | ||
<TBODY> </TBODY> |
<TBODY> </TBODY> |
<TBODY>
</TBODY>