Hi
It would be appreciated if you could help me again.
I now need to compare column A & E, and need to compare col E to col A and to extract data in Col A that does not appear in Col E
Your assistance in this regar is most appreciated
Hi
It would be appreciated if you could help me again.
I now need to compare column A & E, and need to compare col E to col A and to extract data in Col A that does not appear in Col E
Your assistance in this regar is most appreciated
Code:IF(COUNTIF($E$2:$E$18,A2)=0,A2,"")
Bookmarks