LinkBack URL
About LinkBacks
Add a fourth column D with the following formula. I assume you have column headers, with data starting in row 2. Put this formula in D2 and fill down:
Formula:
=IF(A2=B2,"Match","No match")
Then sort on columns A:D using D as the key.
Add a fourth column D with the following formula. I assume you have column headers, with data starting in row 2. Put this formula in D2 and fill down:
Formula:=IF(A2=B2,"Match","No match")
Then sort on columns A:D using D as the key.
Jeff
| | |·| |·| |·| |·| | |:| | |·| |·|
Read the rules
Use code tags to [code]enclose your code![/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks