Hi,
I have a column of data in sheet 1, all numbers.
In sheet 2, I have another number, call it X in a cell.
I need to write a macro that calculates which percentile X finds itself in (relative to the data in sheet 1) and spits it out like this "1st Percentile" or "2nd Percentile" etc.
Have no experience at all with macros, would greatly appreciate any help.
File attached,
Thanks
TR
Bookmarks