Count occurences of a value in a column

[bexxx]

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!!

[fplesco]

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!!

Hi -

This is quite like a high level perspective of your problem but as I see it.

For Row = 1 to TotalRows 
      intColTotalOne = 0
      For Cols = 1 to TotalCols
            if <Grid Object>.Textmatrix(Row,Cols) = "1" then 
               'OR CINT(<GridObject>.Textmatrix(Row,Cols)) = 1
                intColTotalOne = intColTotalOne + 1
            end if
     Next Row
 
     Print intColTotalOne
Next Row
 

[Killer42]

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.

You might want to check your wording, for a start. If you input the number (that is, accept it from the user via keyboard or whatever), then you don't need to calculate it.

Can you give us some more details about the situation? For instance, what version of VB are you using? What kind of "column" are you talking about? Something in Excel or Access, perhaps?

We're not mind-readers.

[Killer42]

... For Row = 1 to TotalRows ...

Thanks for taking a shot at it, fplesco. However, I would question your logic. It looks to me as though you are tallying up and displaying the "1"s per row, not those in a particular column.

[hariharanmca]

Thanks for taking a shot at it, fplesco. However, I would question your logic. It looks to me as though you are tallying up and displaying the "1"s per row, not those in a particular column.

yes you are correct Killer, and need change the for loop's Rows to Column and column into Rows or with help of arraylist he has to print.

[Killer42]

yes you are correct Killer, and need change the for loop's Rows to Column and column into Rows or with help of arraylist he has to print.

If we assume that the OP is using some sort of grid which allows direct access to each cell, as in the posted code, then a requirement to work with a particular column doesn't need nested loops at all. Just one loop, to go through the rows.

[fplesco]

Thanks for taking a shot at it, fplesco. However, I would question your logic. It looks to me as though you are tallying up and displaying the "1"s per row, not those in a particular column.

I got it wrong. I agree with you guys.

Thanks

[hariharanmca]

If we assume that the OP is using some sort of grid which allows direct access to each cell, as in the posted code, then a requirement to work with a particular column doesn't need nested loops at all. Just one loop, to go through the rows.

i cannot get what you mean

which allows direct access to each cell.

If he wants for a single column count. yha it's possible in one 'for'. But if it is contain multipule colume and rows, we have to use 2 'for' loop?

[bexxx]

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 go:
ok in column 1:
1 = 2
2 = 1
3 = 1
4 = 2
Etc. I want it to do this for all three columns and print the values on screen.
Does anyone know how to do this???

[Killer42]

If he wants for a single column count. yha it's possible in one 'for'. But if it is contain multipule colume and rows, we have to use 2 'for' loop?

How many rows or columns are contained in a grid is irrelevant. You only need the nested loops if you want to process multiple columns in multiple rows. That was not what the original question stated. To process a single column, you just need to loop through the rows, accessing the same column each time around the loop.

Anyway, I think this is one of those cases where we're both just saying the same thing, different ways.