Hello great minds, Im a newbie and need help. Using excel 2007.
I have phone numbers in column A that im trying to find in column B using this formula:
=IF(COUNTIF($B$2:$B$663,A2),A2,0)
is there a way I can tell excel to show me the found data highlighted in column B?
thanks in advance.