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
***************************************************
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