Hi,
Please see the attached file.
I am looking for a formula that can be used to define the ranges in column B based on values in Column A. I plan to use this to calculate percentiles for the population in column B, for each of the values in column A. Values in Column B are continuous measures in real data (not Y or N). I am looking for a non-VBA solution ("If" formula).
Thanks
Bharath Srivatsa
Bookmarks