Can Conditional Formatting Ignore Duplicated Information from another Sheet?

[RhysWare]

Hi all,

I currently have a very large sheet of information and a sheet with a Pivot table. Let's say Sheet A and Sheet B respectively.

I of course want to bring the information from Sheet A over to Sheet B, however, I have duplicates on Sheet A that I want to disregard on my Pivot Table. I'm thinking we could do this using Conditional Formatting on the Pivot Table of Sheet B.

Here's the hard part, I need some formula to only ignore duplicates from two columns within Sheet A, specifically J and K.

Is there a way I could do this, and if so could you give me the how to?

Many thanks.

[etaf]

answered here
http://www.mrexcel.com/forum/excel-q...her-sheet.html

[RhysWare]

Hi Wayne,

Thank you for your suggestion. Unfortunately I'm trying to configure this table in a way that the data sheet will not have to be tampered or adjusted with at all, it can just be imported into my pivot table and the table itself will then automatically know to disregard the duplicates in columns J and K.

[etaf]

OK, not sure how to do that directly in a pivot table myself

[RhysWare]

No problem, thank you very much for getting in touch anyway, it's appreciated.

Been tasked with a huge project at work and this is my first problem, I can't quite imagine how the rest will turn out! Haha