Count Unique - Cannot Get my Head Around it

[dhsilv2]

Hi guys,

I know this has been answered multiple times before, but I'm really struggling with understanding how a count unique will work. I somewhat (and I mean somewhat) understand how frequency works and how it can count unique for a single range. Where I get complete confused is in how to handle the more complex cases where there are a greater number of relationships and they are both numerical can text. I'm currently doing rather cumbersome sorting then writing some basic if then statements to return numbers and adding helper columns to do multiple scenarios. This is far too prone to errors not to mention it's time consuming.

So looking at the data below, I might need to do a full unique for all 4 columns and then separately I might just need unique for Area, Account, and Additional.

My goal here isn't so much to get someone to write out the formula, but to understand how it works. Thank you in advance for your help.

<colgroup><col width="81"><col span="2" width="64"><col width="84"></colgroup><tbody>
</tbody>

LOB	Area	Account	Additional
Commercial	Chicago	1101	1
Commercial	New York	2050	2
Commercial	Atlanta	5201	3
Retail	Chicago	1101	1
Retail	New York	8899	2
Retail	Atlanta	9892	3
Investment	Chicago	1101	1
Investment	New York	2220	2
Investment	Atlanta	5586	3
Other	Chicago	9858	1
Other	New York	9598	2
Other	Atlanta	1123	3
Commercial	Chicago	8855	1
Commercial	New York	6985	2
Commercial	Atlanta	5586	3
Retail	Chicago	9858	1
Retail	New York	9598	2
Retail	Atlanta	1123	3
Investment	Chicago	8855	1
Investment	New York	6985	2
Investment	Atlanta	5586	3
Other	Chicago	9858	1
Other	New York	9598	2
Other	Atlanta	1123	3
Commercial	Chicago	8855	1
Commercial	New York	6985	2
Commercial	Atlanta	8589	3
Retail	Chicago	8889	1
Retail	New York	8888	2
Retail	Atlanta	8593	3
Investment	Chicago	8952	1
Investment	New York	1205	2
Investment	Atlanta	11516	3
Other	Chicago	11516	1
Other	New York	11516	2
Other	Atlanta	11516	3

<colgroup><col><col span="2"><col></colgroup><tbody>
</tbody>

 

[MARZIOTULLIO]

HI

https://www.youtube.com/user/ExcelIsFun . Mike Girvin channel .The best tutorial for evry function in excel.

 

[dhsilv2]

HI

https://www.youtube.com/user/ExcelIsFun . Mike Girvin channel .The best tutorial for evry function in excel.

Thanks. I actually read a few things by him before posting this. The combination of multiple text and numbers is where my mind just gets blow and I'll go through the videos but I feel like that scenario is not shown elsewhere, and I'm not getting the basics well enough to combine them. This is a bit frustrating for me as using arrays and complex lookups/index/match type things all came relatively easily. Something here isn't clicking or maybe I"m just getting a bit "slower" with age.

If there's a video in there you know of I need to see for this, please let me know. I'll be viewing those of interest but he's got a lot of them.

 

[AhoyNC]

Take a look at these 2 videos by Mike G.

https://www.youtube.com/watch?v=ELBoMyZxBM0
https://www.youtube.com/watch?v=uUrI8hoj8BA