Forum Discussion

Copper Contributor

Jul 13, 2023

Solved

How to check if all values are same

Hello forum, I need help with the below scenario. I have part numbers with varying 6 digit codes. I need to check if the part numbers has same six digits or if there is a difference. Attached a samp...

Formulas and Functions

Macros and VBA

Riny_van_Eekelen
Jul 13, 2023
HaniroothC Perhaps not the prettiest solution but if you change the layout of the PT a bit and then create a unique list of part numbers, you can use COUNTIF to count the number of times a part number occurs in the PT. Filter out the ones with a count of 1 and you are left with the ones you need to look into.

Or perhaps with Power Query, but since you are on a Mac, you need to have a current MS365 subscription.
haniroothc_2.xlsx25 KB

HaniroothC

Copper Contributor

Jul 13, 2023

Hi Riny, thanks for the response. I tried using pivot table, but since the records I have is large using a pivot table becomes difficult. Is there a possible solution where I can only get the part numbers that have different 6 digits? A logical formula or something?

Riny_van_Eekelen

Platinum Contributor

Jul 13, 2023

HaniroothC Perhaps not the prettiest solution but if you change the layout of the PT a bit and then create a unique list of part numbers, you can use COUNTIF to count the number of times a part number occurs in the PT. Filter out the ones with a count of 1 and you are left with the ones you need to look into.

Or perhaps with Power Query, but since you are on a Mac, you need to have a current MS365 subscription.

haniroothc_2.xlsx25 KB

HaniroothC
Copper Contributor
Jul 13, 2023
Riny_van_Eekelen Thanks so much for the response. It works! 🙂