Google Sheets - Count Duplicate or Unique Values

[@SurgeCola]

Is there a way to link values based on three columns and display them in another column without duplicates? i.e.: product names, UPC, and product descriptor (even just the first two would be fine)

[@JinaneKarhaniRawda]

Very precise & easy, thank you.

[@ProlificOaktree]

You are welcome!

[@karrar6213]

Thanks a lot, that's very helpful

[@ProlificOaktree]

Glad it worked for you

[@conduitedactivitessmartcab736]

thank you for sharing !! when I try the countif formula with arrayformula it doesn't give the same results do you have a solution to propose?

[@KnotsofLove]

Thank You!!! This is exactly what I was looking for and worked first try! Count Unique was what I used. :)

[@ProlificOaktree]

Yeah, that's a great function.

[@Sayuri199x]

Hi, would you know how to count the sum of True or False (on checkboxes) within a specified date? Like for instance: On Column A I have the date a person registered Column B is the day their registration ended Column C is the indication or checkbox, "True" or "Checked" if they have successfully registered and "False" or "Unchecked" if they didn't proceed. Now, I need the summary of how many people successfully registered for each month. Hoping you would notice, i've been watching your tutorials for quite some time and it really helped a lot.

[@ProlificOaktree]

Good morning. I can at least give you a hint! Checked is TRUE and unchecked is FALSE. Don't use qoutation marks around those values in a formula.

[@Sayuri199x]

@@ProlificOaktree good morning! Thank you for responding. Im wondering if you have any tutorial for counting this checkboxes within a month or within specific dates like my example above? Im pretty much familiar with xlookup up to array but im still self studying mostly with the help of your vids 🥹🫶

[@ProlificOaktree]

@@Sayuri199x Try pivot table feature where you can group by date: kzbin.info/www/bejne/gWHTl2WpadRmfsk . Make the values counts of TRUE/FALSE.

[@Sayuri199x]

@@ProlificOaktree I'll try that. Thank you so much!

[@dme9874]

Thanks for sharing...

[@alexisiiflores7342]

thank you!

[@apmkingstrack6509]

Thank you

[@ProlificOaktree]

You're welcome!

[@nickvogelius]

How do I count number of times a value is repeated "continuously" like 1,1,1,3,1,2,1,1 = 3

[@ProlificOaktree]

Great question. You could do a Pivot table and aggregate the values by COUNT. See here for more kzbin.info/www/bejne/iqXcYYWveZZ-gtk

[@waleedaljuhaishe7591]

Hi ، I have cells that have duplicated PO, next cell has the date when the PO arrive. Like 210000. 1-Jan-2022 210000. 2-Jan-2022 210232. 2-Feb-2022 Kindly all I need to count how many POs during Feb and Jan, I have tried, and it shows 3 but it should shows 2 as one PO is duplicated The work on google sheet

[@arul255]

Hi, please can you help that how to duplicate a sheet including protection exists in the sheet. When I duplicate a sheet it's not copying the protections.

[@ProlificOaktree]

I don't know of a way to do that.