The example of what I need to count is as follows:
The data is retreived from a Microsoft Excel Spreadsheet.
In VB6 it prints the following on screen:
Code:
choice1 choice2 choice3 1 4 2 2 3 1 4 2 1 3 1 4 4
bexxx
Last Activity: Aug 10 '07, 01:55 AM
Joined: Jul 31 '07
Location:
-
Count Occurrences of a Value in a Column
Can I please have some simple coding that will allow me to do this?
The example of what I need to count is as follows:
The data is retreived from a Microsoft Excel Spreadsheet.
In VB6 it prints the following on screen:
... -
Ok so ive thought about it and what i really need is a simple count function to go down the column and count the "1"s. Here ill give you an example:
This is what VB prints on the screen (it is information retreived from a Microsoft Excel File)
1 3 4
2 5 1
4 3 2
4 3 1
1 4 3
3 3 5
So i want the code to be able to... -
Count occurences of a value in a column
I need to know how to count the number of "1s" in a column and then input the total number of "1s" in that column on the screen.
Hence counting the total of these numbers in this column.
PLEASE HELP ME!
I will be forever greatful to you if you do!!
No activity results to display
Leave a comment: