Unique Count in Excel | How to count Unique Values in a list using Sumproduct and CountIF Formula

Easiest way to count unique values would be to insert the pivot table for the given table. Now, select the desired column from pivot fields in the row area. This will show only the unique values which can be easily counted by using Count.

If the formula need to be done on a new worksheet..will that work? Am looking for formula to count unique values by country level means a lot of data

=SUMPRODUCT(1/COUNTIF(G4:G42609,G4:G42609)) I am using same for but i am getting zero values please help me

You are genius sir ,Thank you for this video😊😊

Way of explanation is excellent, thanks for sharing your vedios.

But this is not working in pivot for unique count with total

Pls send unique value extract karne ke video link

Sir yadi hame date wise unique value nakalana ho to kaise mikale agar hamare pass ek sal ka Data ho

Sir दो batch example (batch 1 and batch 2 ) ki same date na ho vertical me ye kese kare...I am facing big problem pls help me sir, how can I show data to you sir.

Sir ek aur Problem aur Solve kar dijiye - Count to ho Par Duplicate ke liye 0 aaye

Sir data DATE hua ta tab kiya karenge

Revise, relearn, recap, RRR

Ye series sabse alag hai sir. Baar bar dekhta hu mai

Searching for this type of formula..
Thanks

...aapka dil bohot bada hai bhai....free main itne knowledge sab ko dete ho....🙏...God bless....!!!
You are man of integrity...!!!

Nice sir

Bahot bahatreen. Sabhi formulas ka aapne postmortem kar rakha he

Sir agar dono coloum me se ya 3 coloum me se unique count nikalna hai to kya formula hoga. Please suggest me

Very well explained...

Sir, How to count Unique with multiple criteria like employee id wise channel partners...

DATE WISE MANOPOWR UNIQUE COUNT KA FORMULA BATAYE SIR, LIKE 15 MAY AMAN, JITENDRA = 2 , PLEASE

HiI have more than 50 Lakhs Products IDs and i need to findout duplicates out of this huge data. Pls assist with formula.

Best indian excel guide!!🔥🔥

Wow. Me bhi excel me job karta hu but esa logic me kabhi nahi soch skta

Sir,
Mere pas aysa hi ekta data he lekin sir usme employee visit many customer in a day some Times employee visit same customer two time in a day, mujhe duplicket valu nikal he using same employee visit same customer using function.
Please help

So much respect for you Sir. The way you explained is too good.🙏
Sir how can I count unique value based on condition?

Very difficult... Short me samzao bhai

Dive Deep Thats Innozant

Sir ji isse countifs with sunproducts

Isi farmule main fillter lagana batayiye

Macro with pivot table ke saath kese banayege. Video banaye.

Sir can we find the last nth match value?

Not working on huge data

Please make a video on how to replace series of Duplicate Values with Blanks / Zeros while retaining the first occurrence or last occurrence

Thankyou very much!

Kaam ni hua 0 aa gaya pura

Good teaching

insted of blank if few cells contain "-", then how to delete count of "-"

Respected Dilip Sir,
Your video is too good to learn Excel. Sir I have a problem, how can I get unique man power in sum count between time.

Thank you Dilip sir Maa kali or apke sahyog se mujhe kaafi Kuch shikhne ko mila apne mujhe creative bna diya dhanyavaad gurujii jai maa kali ❤

Hello Sir,
Thanks for Explain this Method,
but I Need Formula or method which can Count numbers of Each Unique Value from Thousands of Duplicated Values..in a Single Row.

How Can I find, how Many time Invoices Bill payment has been failed of Each Customer, Invoices should Not Be repeated.

Please Please he out from below mention Data..


Invoice No. Customer Code Customer Name Amount Credit Date Status
14418F24-000103 IN00003447 M/S F.M. STORE 54831 01-05-2024 Bill Payment Failed
14418I24-000169 IN00003447 M/S F.M. STORE 246408 01-05-2024 Bill Payment Failed
23905I24-000171 IN00004697 M/S DEVBHOOMI ENTERPRISES 94973 01-05-2024 Bill Payment Failed
23905I24-000172 IN00004697 M/S DEVBHOOMI ENTERPRISES 119386 01-05-2024 Bill Payment Failed
23905I24-000172 IN00004697 M/S DEVBHOOMI ENTERPRISES 119386 01-05-2024 Bill Payment Failed
23905I24-000174 IN00004697 M/S DEVBHOOMI ENTERPRISES 98773 01-05-2024 Bill Payment Failed
21120F24-000053 IN00001813 M/S EMPIRE ENTERPRISES 256204 01-05-2024 Bill Payment Failed
21120I24-000192 IN00001813 M/S EMPIRE ENTERPRISES 607572 01-05-2024 Bill Payment Failed
32319I24-000222 IN00002868 Tribebi Enterprise 400309 01-05-2024 Bill Payment Failed
13229I24-000378 IN00000909 AM DISRIBUTORS 299435 01-05-2024 Bill Payment Failed
13229I24-000377 IN00000575 HARMAN BALAJI TRADING 997375 01-05-2024 Bill Payment Failed
13229I24-000377 IN00000575 HARMAN BALAJI TRADING 997375 01-05-2024 Bill Payment Failed
13229F24-000234 IN00017102 KSHIPRAA SHOPPERS 39555 01-05-2024 Bill Payment Failed
13229I24-000365 IN00017102 KSHIPRAA SHOPPERS 53007 01-05-2024 Bill Payment Failed
13229I24-000380 IN00000427 M V ENTERPRISES 271574 01-05-2024 Bill Payment Failed
13229I24-000297 IN00006776 VEERABHADRESHWAR KIRAN STORE 473631 01-05-2024 Bill Payment Failed
13537I24-000310 IN00001702 VENKATA SAI SRI AGENCIES 67066 01-05-2024 Bill Payment Failed
13229I24-000345 IN00003771 BLUE STONE DISTRIBUTOR 327614 01-05-2024 Bill Payment Failed
12327F24-000207 IN00000494 DEEP AGENCIES 68190 01-05-2024 Bill Payment Failed
12327I24-000333 IN00000494 DEEP AGENCIES 224286 01-05-2024 Bill Payment Failed
14418F24-000109 IN00007939 En Punto 135087 02-05-2024 Bill Payment Failed

brother counta with unique function does the same thin

Sab filter lagane pe kamm nahi karata pura count hi batata hai

👽 माइंड

Hi Dilip Sir,
Will you please tell me the process to extract uncommon record set from different sheet or different workbook?

sir jee, i m from Pakistan, this sumproduct formula not working when we apply filters, please resolve ?

Amazing

Thanks for this

Sir unique count ka multiple sheet main bhi batao ek saath without unique and vstack ke