RANK function in Numbers
I am trying to use the rank fuction for a spreadsheet and I can't figure it out. I have it set in Excel, but I can't transfer to numbers (and still work in excel).
I have 3 values in the same column:
M13 = 346
M27 = 352
M41 = 331
I need to rank these using 1st, 2nd, 3rd, with the results posting to the following cells:
M14
M28
M42
Any help?
Thanks!
iPad 2