Tap / click on image to see more RealViewsTM
$32.95
per mug
Excel formula: formula countif and Unique Coffee Mug
Qty:
Style
Classic Mug
+$1.90
+$3.65
+$18.60
Size
About Mugs
Sold by
About This Design
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
Customer Reviews
4.8 out of 5 stars rating22.2K Total Reviews
22,222 Reviews
Reviews for similar products
5.0 out of 5 stars rating
5 out of 5 stars ratingBy 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.
5.0 out of 5 stars rating
5 out of 5 stars ratingBy S.20 June 2021 • Verified Purchase
Classic Mug, 325 ml
Zazzle Reviewer Program
Very happy with the printing and overall quality of the personalized welcome pack for our employees. Great quality and placement, very happy with how it turn out!
5.0 out of 5 stars rating
5 out of 5 stars ratingBy 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.
Tags
Other Info
Product ID: 256249471402100505
Posted on 17/01/2023, 6:17 PM
Rating: G