Excel - Do a Count of Unique Values | Text and/or Number | Get a Count of Unique Values in Excel

In this video I demonstrate how to add up times in Excel. Times are stored as numbers in Excel, so it is possible to add them up or subtract them.

Things get more involved when you add up a total of times that exceed 24 hours - this video demonstrates a formatting trick that solves this problem.

The video also explores how to calculate elapsed time across multiple days. So for example you may start a shift on Monday evening and finish it early Tuesday morning.
------------------------

[Alebobb]

THAT SUMPRODUCT FORMULA IS F GOLD! THANKS A LOT

[IvanCortinas_ES]

Excel365 - More or less fast formula (artificial intelligence). You're a machine.
Old school Excel - Think, analyze the problem, formulate with mathematical tricks or the like. You are a human being.
Thank you Chester for this comparative!

[jacobm]

What about when you want to count the unique values in 1 column based on meeting a requirement in a different column?

[javidiaz]

Marvelous just what I was looking for. Thank you.

[AmbutuMalone]

THAN YOU! YOU MADE MY LIFE SO MUCH EASIER!

[dbmnfinity]

Thank you, I have been searching online forever to find this

[HardenTheGift]

A nice math session here. I'll take option 2!

[alitamine]

Thanks so Much, very smooth Explanation !

[raibishwa]

Thanks a lot, it is more useful than ChatGBT

[patrickschardt]

365 made the challenging very easy. It’s neat to see how this used to be done

[nedisyadani]

i got error #div/0! in output column...what does it mean? need help, thanks

[mubashir]

It works well but give #DIV/0! error if there is a blank row

[sewingmachine]

Thank You, these seem to be the best explanations I have found. Understood them and applied them both well. However, I need this function (I have tried the COUNTA version) within the SUBTOTAL feature, but Excel give me an error. Can anyone please help ?

[snchitre]

How to count unique rows with one more filter condition in a table?

[haro]

The formula gives an error if empty cells are selected. Is there a variant that ignores empty cells?

[ciprianmihai]

Thank you for this formula. Please help me. How do i subtotal this on 365?

[surennair]

How would you add another criteria. e.g if you had another column which had yes or no. How would you work out the unique value for the Yes/no

[ion]

Hi I am trying to achieve this but with two columns. I have a huge list of vendors in [column b] and in [column c] I have different codes that can be repeated for the same vendor depending on the date. Now I made a [column a] where i want to show the distinct code values specific for each vendor. I can achieve a unique value for one column no problem but how do i tell excel that i want it to: based on the value of b, count the unique code values that only applies to that vendor and not spill through the other vendors I might have. So for example I can make a pivot table out of the data adding it to the data model and then i place the vendorson rows and codes on values (then making them distinct) and i get each vendor with the unique count of codes for each and if i double click i get the list with all the information but that dont work for my purposes becasue excels makes a new sheet for me to be able to see the information whereas would be better if i have the distinct next or before the vendor in the complete data. Just in case, Im using excel 365.

Thank you for the video and explanation it was very easy to understand.

[amarendrabehura]

Hi, I have two worksheet, I want count unique value based on column match criteria

[CCAFO]

Hello, if you can show how to count only one if there are the same value in other cell