hey guys
ok basically ive got data in Columns A,B that i need to match with D,E and find the differences between the 4 columns and report them
hey guys
ok basically ive got data in Columns A,B that i need to match with D,E and find the differences between the 4 columns and report them
Assuming you have headers in row 1, how about something like:
Formula:=COUNTIFS(A:A,A2,B:B,B2)=COUNTIFS(D:D,D2,E:E,E2)
TRUE signifies instances where there is a two column match in both sets of data.
BSB
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks