Dear All respected members,
I received an excel data from one of the Korean Companies named "HYOSUNG CORPORATION" (as attached), which is required for Badge Printing.
There are so many companies in the same format with much more data. Here, counting of names manually will become slightly difficult.
Is there any way to count total number of persons for "HYOSUNG CORPORATION" with formula. Here the result is 40.
The main point here is The columns are not merged. The Blank row can not be deleted due to setting in the printer.
Is the net result can be achieved any formula ? help is requested.
Please accept my apologies if it is illogical.
VDS
I received an excel data from one of the Korean Companies named "HYOSUNG CORPORATION" (as attached), which is required for Badge Printing.
There are so many companies in the same format with much more data. Here, counting of names manually will become slightly difficult.
Is there any way to count total number of persons for "HYOSUNG CORPORATION" with formula. Here the result is 40.
The main point here is The columns are not merged. The Blank row can not be deleted due to setting in the printer.
Is the net result can be achieved any formula ? help is requested.
Please accept my apologies if it is illogical.
VDS