type =select row2 in file1column1again type =select file2select row 2 of file2column2
If you do it a few times then you would become comfortable.
should I sort both column in the same order first then compare based on this ?
I copied the same colujmn from other excel to the same excel side by side now, what should I do ?
=IF(ISERROR(MATCH(B2,$A$2:$A$7,0)),"Not found","Found on row "&MATCH(B2,$A$2:$A$7,0))
Select allOpen in new window
© 1996-2022 Experts Exchange, LLC. All rights reserved. Covered by US Patent