which cell is different

[SamS]

I have about 2500 rows and 7 columns of data A - G (text), each row of data should be the same information in each of the columns but as it turns out people have modified some data even when asked not to. In column H, I would like a formula to return the odd piece of data in each row, is this possible without resorting to VBA.

Column A is what the cells should be matched against as this was the original data.

 

[Peter_SSs]

With the sample data given (no spaces in each cell) and multiple differences, you could list them all like this:

Excel Workbook
	A	B	C	D	E	F	G	H
1	a	a	a	a	a	w	a	w
2	b	b	x	b	y	b	b	x y
3	c	c	c	c	c	c	c
4	d	d	q	w	e	r	d	q w e r
Find Difference

 

[SamS]

Peter, thanks so much, I have rebooted my other PC and the file is back up and running. I tried your previous solution and it worked. I will play with your second solution but I also need time to digest the formula you have provided.

Lasw10 - I also thank you as I had some thoughts along the line you were taking with the CHOOSE function but could not get it to work.

 

[SamS]

With the sample data given (no spaces in each cell) and multiple differences, you could list them all like this:

Excel Workbook
	A	B	C	D	E	F	G	H
1	a	a	a	a	a	w	a	w
2	b	b	x	b	y	b	b	x y
3	c	c	c	c	c	c	c	*
4	d	d	q	w	e	r	d	q w e r
Find Difference

Peter, thisst formula picked up =SUBSTITUTE(CONCATENATE(B1,C1,D1,E1,F1,G1),A1,"") other errors as well so I did not need to adjust the formula at all, once again many thanks.