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