Hello, Does anyone use or know of any formulas, functions, shortcuts or any other easy way to formulate a decile report or column.
For example, I have 600 store numbers that have a number asigned to them in a second column, that I want to decile out. Right know, I sort from high to low on the value, divide by 600 and put a number in each line. after line 61 for example, I put the second decile number, and so forth.
As you can imagine, this is vary time consumiong, especially when they are multiple colmns for that store that need to be deciled out.
Thanks for your help.
Bookmarks