Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

User profile for user: CuriousGeorge101
CuriousGeorge101 Author
User level: Level 1
8 points

Count one of each value

Hi there,


I have been trying to search a formula for this since hours but I cannot figure it out. So basically I have a data as shown in the screenshot below. This is a huge table containing about 15,000 raws.


What I want to do is separate out the sizes for each country. For example, US Store could have sizes 6, 6.5, 7, 8, 8.5 etc. (Not all store has same sizes hence, I need to figure out)


Is there any formula to help me get this data?


Ps. I have tried using filter option but it misses out certain sizes for some reason.


MacBook Pro 13″, macOS 12.0

Posted on Dec 1, 2021 12:07 AM

Reply
Question marked as Top-ranking reply
User profile for user: SGIII
SGIII
User level: Level 8
36,512 points

Posted on Dec 1, 2021 6:03 AM

Try a Pivot Table something like this:





Click in table with data, and from the menu choose Organize > Create Pivot Table > On Current Sheet. Then in Pivot Options drag 'US' down into the 'Rows' box. Copy-paste the distinct values into another table if you want. Then replace 'US' with 'Europe in the box, and so on.


SG

View in context
2 replies
Sort By: 
Question marked as Top-ranking reply
User profile for user: SGIII
SGIII
User level: Level 8
36,512 points

Dec 1, 2021 6:03 AM in response to CuriousGeorge101

Try a Pivot Table something like this:





Click in table with data, and from the menu choose Organize > Create Pivot Table > On Current Sheet. Then in Pivot Options drag 'US' down into the 'Rows' box. Copy-paste the distinct values into another table if you want. Then replace 'US' with 'Europe in the box, and so on.


SG

Reply

Count one of each value

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.
Learn more Sign up