concatenate the columns into a single cell in the master sheet....
=A1 & A2 & A3 etc... This should return a single value
Do the same for the data sheet...
=Data!A1 & Data!A2 & Data!A3 etc...
Then do a match to return a true/false value.
concatenate the columns into a single cell in the master sheet....
=A1 & A2 & A3 etc... This should return a single value
Do the same for the data sheet...
=Data!A1 & Data!A2 & Data!A3 etc...
Then do a match to return a true/false value.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks