Hi Guys,
I am trying to determine whether a combination of values contained in cells within one sheet exist in any row contained within another sheet
i.e. are ALL of the values contained between cells A2-BB2 in 'Sheet 1' equal to ALL of the values in ANY row contained between cells AZ-BB2 in 'Sheet 2'
Additionally, I am also trying to compare two lists of data of unequal size to identify any differences i.e. List 1 contains 15 values and List 2 contains 20 values. In this case obviously 5 values are missing so I want to be able to compare the lists of data so that a separate column is returned showing the values in 'List 1' that are not in 'List 2'
LIST 1 LIST 2 MISSING VALUES
2 2 5
3 3 6
4 4
5
6
Finally, is there anyway that I can format cells so that the cell values are being compared properly? Currently, for some of the sheets I have even though the numbers are the same between sheets, they are still showing up/being returned as differences even when I am trying to perform exact match comparisons. There is like a red comma on the top left hand side of the cell which I think is casing this problem so it would be useful to know how to get rid of this.
Thanks a lot for your help guys!
I am trying to determine whether a combination of values contained in cells within one sheet exist in any row contained within another sheet
i.e. are ALL of the values contained between cells A2-BB2 in 'Sheet 1' equal to ALL of the values in ANY row contained between cells AZ-BB2 in 'Sheet 2'
Additionally, I am also trying to compare two lists of data of unequal size to identify any differences i.e. List 1 contains 15 values and List 2 contains 20 values. In this case obviously 5 values are missing so I want to be able to compare the lists of data so that a separate column is returned showing the values in 'List 1' that are not in 'List 2'
LIST 1 LIST 2 MISSING VALUES
2 2 5
3 3 6
4 4
5
6
Finally, is there anyway that I can format cells so that the cell values are being compared properly? Currently, for some of the sheets I have even though the numbers are the same between sheets, they are still showing up/being returned as differences even when I am trying to perform exact match comparisons. There is like a red comma on the top left hand side of the cell which I think is casing this problem so it would be useful to know how to get rid of this.
Thanks a lot for your help guys!
