Multiple differing results need to be highlighted with a formula...

**teenyjem** · 05-20-2013, 10:11 AM

Hi. I need some help...

I have a spreadsheet that I need a little help on. Attached is the sheet. All data has been changed and is hypothetical.

Imagine a world where seperate parts of the microsoft office package need a seperate part serial number to access. ie word needs its own license. but i have two same licenses and they are linked to both excel and word. oh no. this must mean i have corrupt data somewhere... i need to identify where the duplicates are and highlight them for further investigation.

Can you have a quick looksee at my sheet and tell me if you can help with a formula to identify i have an issue...

Or if you can think of a better way of identifying my problem.

As you can see, the green are not erroneously linked to multiple products, but the grey are. I cant think what i could use to highlight this without looking thru manually...

thanks very much in advance,
t

**Pauleyb** · 05-20-2013, 10:28 AM

Put this in D2 and then drag down:
=IF(COUNTIFS($B$2:$B$21,B2,$E$2:$E$21,"<>"&E2)>0,"Multiple Values",E2)

**Pauleyb** · 05-20-2013, 11:28 AM

Not sure why, but my first post is not showing up as a response in the summary page. Teenyjem may think it is unanswered. Adding this note to try to show a response.