I have four columns of data, each of different length. I would like to analyze each of the columns of data by quintiles. That is, for example, from a sorted list of 100 pieces of data, I want to analyze the first 20, the second 20, etc. The problem is that I don't know how long (i.e. how many bits of data) each column will be.
I tried to count the non-blank cells in each column, divide this by five, and assign cell references to various cells (see my example s-sheet). However, when I use the MAXIMUM function and reference the cells containing the actual cell references, it only returns the maximum--an error, in fact--from the cells containing the cell references, not the range of cells to which they refer. Can this be made to work?
Is there a better way to do this?