Total of companies in sheet But having a problem

[Mikelowrey]

Hello,

I have a sheet with over 50K companies, now here is the thing, some companies repeats themselves in the sheet because the have multiple licenses. What I would like to know is how can I know the total of companies "by name" even tho they have multiples licenses.

Hopefully I wrote the right way..

thank you !

 

[Aladin Akyurek]

Sure,
total of 80,368 = 69,766

First 10 Row:

10 = 10

ROW FROM G33 TO G48

16 =14

Nice!

Not sure what the foregoing is or indicates. What I'm after is 1o rows from the column G (nly the relevant data).