Expression for Query Help

[fikeplay]

Hey Community,

This will be my first post, so id like to thank you in advance for all your excellent work so far.

I work for a apparel company and I have an excel sheet that has three important columns in it:
1. Email Address
2. Size
3. Count Of Size



I would like to write a query that ONLY shows me the largest quantity per email address. I am only concerned with Email Addresses that purchased a particular size the most. (The 'Count Of Size' column is how many times they purchased that particular size.)

Does anybody know what expression to write in my query to accomplish this?

[fikeplay]

Please disregard this post. I Think i figured it out.

I never had to use the 'Max' function before