• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Formula need to count of unique nos when all rows are full with data

R

Ram Mher

Member
Hi everyone

I have data in Column A from 1st cell to last cell and then same type of data is in B and C columns also from 1st to last cells.

I need a summary with count of each item. Files is not uploading because file size is 37 MB.

Please provide the solution.


Thanks in advance.
Regards
Ram
 
Ram Mher said:
Hi everyone

I have data in Column A from 1st cell to last cell and then same type of data is in B and C columns also from 1st to last cells.

I need a summary with count of each item. Files is not uploading because file size is 37 MB.

Please provide the solution.


Thanks in advance.
Regards
Ram
Click to expand...

As I understand, there are repetitive value in column A, B and C. You can just paste the contents of column B and C to Column A, create a pivot table and get the unique values with count of each unique value.
 
going to need some more information:

- are all of the available rows for Col. A, B, C filled?
- are you looking for a count of unique values or a count of ALL values?
 
Dear Json, thanku very much for viewing the message.
yes, all available rows of column A ,B and C are filled.
I am required count of all values not count of unique values.

Dear Debraj , provided link is not opening please send demonstration in a excel file.
Formula (=Dec2HEX (3563) is also not working.

I hope that now question is very clear and i may get the solution.
 
depending on where you want the count totals to show up (some columns to the side, new worksheet, etc...)
E1=count(A:A)
F1=count(B:B)
G1=count(C:C)

??
 
json said:
depending on where you want the count totals to show up (some columns to the side, new worksheet, etc...)
E1=count(A:A)
F1=count(B:B)
G1=count(C:C)

??
Click to expand...
Dear Jason
By this formula we can count the total values of a coloumn. I need count of each items on seperate sheet from these 3 columns. .Please come back with another solution.

Thanks for the nice cooperation.
 
Hi,

maybe the way is to use a Dictionary object … Search code here or from others forums,
documentation from inside VBA help and also from MSDN …

Can't do anything else without a sample file attached … How many items ?​
 
Last edited:
Ram Mher said:
I need a summary with count of each item. Files is not uploading because file size is 37 MB.
Click to expand...
Hi, Ram Mher!
The built-in feature support files up to 1Mb, however you could upload greater files at any other cloud service (preferably DropBox), trying to crop you file to a more reasonable size than 37Mb. If you work a little, maybe some others would work a little too; if you don't work at all, everybody will follow your example.
Regards!
 
Hi, Debraj(ex-Roy)!
I don't know if URLs work, but I love that Carlsberg green lines that you used for box borders.
Regards!
 
You must log in or register to reply here.
Back
Top