Forum Discussion
How do I make 2 columns match/line up with one another with matching data?
That could help too. I am looking for any way to make it easier or show. Twifoo
You could use this formula in Column C, starting in C2, copied down rows:
=IFERROR(INDEX(A$2:A$10,
AGGREGATE(15,6,
1/((COUNTIF(B$2:B$10,A$2:A$10)=0)*(COUNTIF(C$1:C1,A$2:A$10)=0))*(ROW(A$2:A$10)-1),1)),"")See the sample in the attached file.
I have tried the formula and it does not go pass 10 rows. I have copied and moved column A down to highlight all the cells and did the same thing in column B and still comes up as 0 in Column C. I see in your download/sample file it displayed the difference but if change the numbers (copy/paste) out, nothing occurs. The first 10 rows I know match but going farther does nothing. I must be not doing something right. Even if I change all the A's to the ending row number and the B number row, still nothing occurs any different. Twifoo
The formula returns the correct results only until Row 10 because the ranges are static. Such ranges in the attached version of the file are now dynamic, such that the formula in C2, copied down rows, has been modified to:
=IFERROR(INDEX(ListA,
AGGREGATE(15,6,
1/((COUNTIF(ListB,ListA)=0)*(COUNTIF(C$1:C1,ListA)=0))*(ROW(ListA)-1),1)),"")