Counting Number Of Unique Entries (CountIf Function)

Excel function tutorials

I received a question that made me think of something I had tried to do in a spreadsheet a few months ago but never got around to discuss on this blog. Suppose that you have a large set of data that looks like:

There are a large number of things that could be done with such a set of data but one always tricky aspect is getting answers to questions that involve multiple columns. For example, if someone were to ask you, how many different locations of the store sold at least 1 Early Grey Russian black tea box on each day? I cannot simply add up the number of sales since some stores sell multiple boxes. What could I do? I’ll add 2 columns and include the “countif” function which will give me my answer:)

First, I will create a column with a “UniqueID” with the concactenate:

Then, I will use the “countif” function to see if the ID is unique:

As you can see, all numbers that are “1” are non-Unique. I can then manipulate that column in different ways

As always, you can download the spreadsheet here:)

***************************************************

Look Good at Work and Become Indispensable Become an Excel Pro and Impress Your Boss


***************************************************

35 Feedbacks on "Counting Number Of Unique Entries (CountIf Function)"

Internet Marketing Miami Beach

Internet Marketing Miami Beach…

Experiments in Finance…



best gradual fake tan

best gradual fake tan…

Experiments in Finance…



onrpg Forums

onrpg Forums…

Experiments in Finance…



tom clancy's the division key

tom clancy’s the division key…

Experiments in Finance…



faringitis kronik

faringitis kronik…

Experiments in Finance…



art glass supplies of oklahoma

art glass supplies of oklahoma…

Experiments in Finance…



fiberglass standard dock box marine model 524

fiberglass standard dock box marine model 524

Experiments in Finance



spray tanning Machine ebay

spray tanning Machine ebay

Experiments in Finance



fake tank

fake tank

Experiments in Finance



cheap movers west palm beach

cheap movers west palm beach

Experiments in Finance



guide to cold reading

guide to cold reading

Experiments in Finance



drgracedc.com

drgracedc.com

Experiments in Finance



hcg weight loss nashville

hcg weight loss nashville

Counting Number Of Unique Entries (CountIf Function) | Experiments in Finance



visit the following website

visit the following website

Counting Number Of Unique Entries (CountIf Function) | Experiments in Finance



monster high dress up games please

monster high dress up games please

Counting Number Of Unique Entries (CountIf Function) | Experiments in Finance



obat herbal asam urat

obat herbal asam urat

Counting Number Of Unique Entries (CountIf Function) | Experiments in Finance



cartas de amor para mi novio originales de cumpleaños

cartas de amor para mi novio originales de cumpleaños

Counting Number Of Unique Entries (CountIf Function) | Experiments in Finance



promotional items tf2

promotional items tf2

Counting Number Of Unique Entries (CountIf Function) | Experiments in Finance



mejores aplicaciones Gratis Play store

mejores aplicaciones Gratis Play store

Counting Number Of Unique Entries (CountIf Function) | Experiments in Finance



Videntes Sin Preguntas

Videntes Sin Preguntas

Counting Number Of Unique Entries (CountIf Function) | Experiments in Finance



dominios internet

dominios internet

Counting Number Of Unique Entries (CountIf Function) | Experiments in Finance



tarot horoscopo

tarot horoscopo

Counting Number Of Unique Entries (CountIf Function) | Experiments in Finance



Vidente Fiable

Vidente Fiable

Counting Number Of Unique Entries (CountIf Function) | Experiments in Finance



jaegerforbundet.dk

jaegerforbundet.dk

Counting Number Of Unique Entries (CountIf Function) | Experiments in Finance



Tutor Singapore

What i don’t realize is in truth how you are no longer really a lot more well-appreciated than you may be now.
You’re so intelligent. You realize thus considerably in the case of this matter, made me for my part believe it
from numerous various angles. Its like women and men don’t seem to
be fascinated until it is one thing to accomplish with Woman gaga!
Your own stuffs excellent. At all times maintain it up!



hidratarea

hidratarea

Counting Number Of Unique Entries (CountIf Function) | Experiments in Finance



chan brother jakarta

chan brother jakarta

Counting Number Of Unique Entries (CountIf Function) | Experiments in Finance



google

google

Counting Number Of Unique Entries (CountIf Function) | Experiments in Finance



hidrataçãO para cabelos loiros e finos

hidrataçãO para cabelos loiros e finos

Counting Number Of Unique Entries (CountIf Function) | Experiments in Finance



remodel bathroom cost Virginia

remodel bathroom cost Virginia

Counting Number Of Unique Entries (CountIf Function) | Experiments in Finance



ブランドコピー 財布実物写真、付属品を完備しております。迅速、確実にお客様の手元にお届け致します。低価格を提供すると共に、品質を絶対保証しております。商品の交換と返品がで

[url=http://www.ooobag.com/wallet/louisvuitton/index_6.html]ブランドコピー 財布実物写真、付属品を完備しております。迅速、確実にお客様の手元にお届け致します。低価格を提供すると共に、品質を絶対保証しております。商品の交換と返品ができます。●在庫情報随時更新!◆お客さんたちも大好評です:◆新品種類がそろっています。◆品質がよい、価格が低い、実物写真!◆100%品質保証 ![/url]



ルイヴィトンコピー 偽物激安ヴィトンコピー 販売階のほらを輸入する資格があって、全国の第一項のナイロンのふろしき包みは傲慢なシリーズの女性を配合して包んで、高級で派手で、私

[url=http://www.newkakaku.com/lb5.htm]ルイヴィトンコピー 偽物激安ヴィトンコピー 販売階のほらを輸入する資格があって、全国の第一項のナイロンのふろしき包みは傲慢なシリーズの女性を配合して包んで、高級で派手で、私達はただふろしき包みの中のハイエンドのブランドだけをしま。ハイエンドのファスナー、私達の採用の高級なファスナーは大工場のOEMからで、ファスナーが順調で滑るのは丈夫で、高品質と高享受。[/url]



保温性に優れたダウンジャケット厳しい審査に合格したダウンを採用しているため、真冬でもTシャツ+ダウンジャケットでも充分過ごせる程の非常に高い保温性があります。当店のスタッフ

[url=http://www.bagkakaku.com/vuitton_bag/2/N51207.html]保温性に優れたダウンジャケット厳しい審査に合格したダウンを採用しているため、真冬でもTシャツ+ダウンジャケットでも充分過ごせる程の非常に高い保温性があります。当店のスタッフも、冬場はダウンジャケットの下は薄手のインナーで過ごしています。本店の商品は100%本物保証!人気の愛であるというモンクレールダウンジャケット マヤを激安通販!2016年冬春モンクレール新作など激安セール。お客様一番の選択と言えます![/url]



rustic wedding shower invitations

Haha yea I showed my gf and it was the first thing she



JanellX

I have noticed that your website needs some fresh content.
Writing manually takes a lot of time, but there is tool for this boring task, search for; unlimited content Wrastain’s tools