Excel VBA

Closed
ArthiSenthil Posts 2 Registration date Thursday June 6, 2013 Status Member Last seen June 6, 2013 - Jun 6, 2013 at 09:33 AM
ArthiSenthil Posts 2 Registration date Thursday June 6, 2013 Status Member Last seen June 6, 2013 - Jun 6, 2013 at 10:53 AM
To count the number of "1","2","3" in a particular sheet.
plz answer me quickly.

2 responses

Blocked Profile
Jun 6, 2013 at 09:46 AM
Good Morning. I would be happy to assist yuo in a timely manner, but the question is open ended and I am not certain what you are asking.

You can Sort, or Filter already by right clicking on the column, it you needed to only find cells with a particulare value. USe the Sort of Filter. Pease let me know what you are counting. Are you tryning to write a formula or a VBA Macro?
0
ArthiSenthil Posts 2 Registration date Thursday June 6, 2013 Status Member Last seen June 6, 2013
Jun 6, 2013 at 10:53 AM
Hi thanks for ur quick rply,

I want VBA coding only. I ll explain u clearly, plz give me solution.

In sheet 1 we are having number of values, like 1,1,1,1,2,3,4,5,5,5,6,6,6,7,4,3,2,2,2,2,etc in different cell.we dont no how

I want to count the total number of 1 ie. total counts of 1 in that sheet1.
0