Comparing group data

Hi All,

Am having issue to compare data at work, usually I'll use filter to look at it line by line (around 3000)...and usually takes me days to validate data.

Heard there are many function in excel can spot the different, would like to ask the expert for:

1. Excel will tell Example B and Example D contains data inconsistency of the Date in Column B

Example A 1/1/1900
Example A 1/1/1900
Example B 1/1/1900
Example B 1/1/1900
Example B 1/2/1900
Example C 1/1/1900
Example D 1/3/1900
Example D 1/3/1900
Example D 1/2/1900
Example D 1/1/1900
Example D 1/4/1900

Thanks

Alan

Hi, welcome to the forum

What are the chances of the same "difference" appearing more than once?

if that will never happen, try this...

	A	B	C
1	Header1	Header2
2	Example A	1/1/1900
3	Example A	1/1/1900
4	Example B	1/1/1900
5	Example B	1/1/1900
6	Example B	1/2/1900	check
7	Example C	1/1/1900	check
8	Example D	1/3/1900
9	Example D	1/3/1900
10	Example D	1/2/1900	check
11	Example D	1/1/1900	check
12	Example D	1/4/1900	check

C2=IF(COUNTIFS(A:A,A2,B:B,B2)>1,"","check")
copied down

Hi FDibbins,

That's beautiful work! Love it.

That works if value Cell A is not an unique. Is there a way that let Excel know to ignore/to tag unique value?

"What are the chances of the same "difference" appearing more than once?"
The chances is about 10-20% because the operator always make the same mistake again and again.

Think you've some concern that im not aware of.... may I know what's that?

Regards,
Alan