Lets say I have a column of numbers. I want to know how many are less than a certain value. In other words I need to know the count of cells that pass a certain argument or test for being less than (or greater than for that matter) a certain value. How do I do this?
Try taking a look at the =frequency formula. It's an array formula that I use for making histograms. I don't have a chance right now to look into the details right now but I think that this should be able to do what you are after.
You can set a $ condtion for the cells in the formula so when you copy it won't change the cell value. ie if nominal value is in cell C47 you can use valuecell>$c$47 it will lock the nominal cell in any copying you do.
I'll check it out thanks I'll check it out.
What about copying your nominal to the cells below it?
Either that or if your nominal is constant, you could put the nominal in as a number in your formula rather than as a cell reference.
I want to avoid a spreadsheet with shiit all over the place, I'd rather not clutter things. I was able to use replace to fix the formulas instead of editing each one but my goal is to evaluate a name (set of data).
Try taking a look at the =frequency formula. It's an array formula that I use for making histograms. I don't have a chance right now to look into the details right now but I think that this should be able to do what you are after.
You can set a $ condtion for the cells in the formula so when you copy it won't change the cell value. ie if nominal value is in cell C47 you can use valuecell>$c$47 it will lock the nominal cell in any copying you do.
I'll check it out thanks I'll check it out.
What about copying your nominal to the cells below it?
Either that or if your nominal is constant, you could put the nominal in as a number in your formula rather than as a cell reference.
I want to avoid a spreadsheet with shiit all over the place, I'd rather not clutter things. I was able to use replace to fix the formulas instead of editing each one but my goal is to evaluate a name (set of data).
