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.
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.