hi there, another excel question. So I have 2 columns of interst in my spreadsheet. One column is a modulus of a running time score (all values range from 0-2000). The other column is a series of 0's, and some other numbers not of interst. I am interested in all of my modulus values that have 0 values in the other column. What I want to do is create a third column that bins modulus values in increments of 50. I need to do this so that I can graph my data: number of responses (0's) across time (modulus). I can see what to do, and have been manually counting and entering the count, but is taking way too long. Any advice? Thanks!
example:
0... 145...
0... 300...
0... 175...
1.. not intersted in 1's...
0... 325...

Could you post a small sample spreadsheet with a manually sorted column.

You could start by sorting the data so that all the 0 related columns are at the top, to do this select the first two columns, then click 'Data' > 'Sort', sort the data 'Ascending' by the column with the '0's' in!

What do you want to do with this data then?