Tap / click on image to see more RealViewsTM
Sale Price $29.66.  
Original Price $32.95 per mug
You save 10%

Excel formula: formula countif and Unique Coffee Mug

4.8 out of 5 stars rating
22348 Total Reviews |
by
Qty:

  1. Style

  2. Size

Other designs from this category

About Mugs

Sold by
MugCreate your own from scratch

Style: Classic Mug

Give a made-to-order mug from Zazzle to someone special, or treat yourself to a design that brings you joy or makes you laugh. Create your own photo mug, shop our collection of the funniest joke mugs, personalise your mug with a monogram, or express yourself with one of our 10 million designs.

  • Available in 325 ml or 443 ml
  • Dimensions:
    • 325 ml: 8.1 cm D x 9.7 cm H
    • 443 ml: 8.6 cm D x 11.4 cm H
  • Microwave and dishwasher safe
  • Use caution when removing the mug from the microwave. Use a pot holder or glove as necessary if it is too hot to the touch. Do not microwave an empty mug
  • Strong, ceramic construction
  • Meets FDA requirements for food and beverage safety
  • Do not overfill and be careful with hot liquids that may scald
  • Keep out of reach of children when filled with hot liquid

About This Design

Excel formula: formula countif and Unique Coffee Mug

Excel formula: formula countif and Unique Coffee Mug

The formula =COUNTIF(UNIQUE(A1:A10),A1:A10) is used to count the number of unique occurrences of a value within a range of cells. The formula works by first using the UNIQUE function to return a list of only the unique values within the range A1:A10. Next, the COUNTIF function is used to count the number of times each value in the range A1:A10 appears in the unique list. This formula is special because it allows you to quickly and easily count the number of unique occurrences of a value within a range of cells without having to manually sort through the data or use advanced formula combinations. This can be useful in a variety of situations, such as tracking the number of unique items sold in a store or counting the number of unique visitors to a website.
Store
Artwork designed by
Spokane, WA, United States
View their Store

Customer Reviews

4.8 out of 5 stars rating22.3K Total Reviews
19679 total 5-star reviews1859 total 4-star reviews352 total 3-star reviews162 total 2-star reviews296 total 1-star reviews
22,348 Reviews
Reviews for similar products
3.0 out of 5 stars rating
3 out of 5 stars rating
By Lisa S.18 October 2026 • Verified Purchase
Classic Mug, 325 ml
I have ordered from zazzle before and it was perfect. This time the mug has arrived in great time but the mug has rubbed on the box and has affected the image, I was hoping to get in touch with the creator but can’t seem to find a way of contacting them. We would love another sent out maybe wrapped in bubble wrap to protect the image. Would love to hear back from the creator. Kind regards, Lisa.
5.0 out of 5 stars rating
5 out of 5 stars rating
By Anonymous14 December 2025 • Verified Purchase
Classic Mug, 325 ml
Easy to order online. I had to get in touch regarding the customizing- response was prompt and helpful. Mug arrived perfectly customized, and well within the expected delivery time frame.
5.0 out of 5 stars rating
5 out of 5 stars rating
By Kirsty D.7 May 2021 • Verified Purchase
Classic Mug, 325 ml
Zazzle Reviewer Program
Very pleased with the product. Arrived well packaged in one piece and looks good. Exactly as per picture.

Tags

count unique valueexcel

Other Info

Product ID: 256249471402100505
Posted on 17/01/2023, 6:17 pm
Rating: G