I am running the Quartile function on a data set.
the dataset includes collumns a-j
the quartile function is run on collumn D. (square footage). The data is sorted by this collumn, so each quartile is a continuous range.
HOW do I return the rows for each quartile??
I need to know what rows each quartile is including.
so I would have Quartile 0 = rowX (0 being the low point)
Quartile 1 = row y to row z
Does anyone have a VBA function which will give me this data?