Excel VBA

[Closed]
Report
Posts
2
Registration date
Thursday June 6, 2013
Status
Member
Last seen
June 6, 2013
-
Posts
2
Registration date
Thursday June 6, 2013
Status
Member
Last seen
June 6, 2013
-
To count the number of "1","2","3" in a particular sheet.
plz answer me quickly.

2 replies


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?
Posts
2
Registration date
Thursday June 6, 2013
Status
Member
Last seen
June 6, 2013

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.