Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Need a formula that would make life easier
I have a basic spreadsheet for my work that keeps track of sales for a promo
that we have going on. I woulds like a formula that will tell me who is rank 1, 2, 3, 4,....so on. I have it so the final number in each category is a percent and would like to have a ranking that automatically adjust when the percentiles changes. thank you. |
#2
|
|||
|
|||
=RANK(A1,$A$1,$A$100)
-- HTH RP (remove nothere from the email address if mailing direct) "Frustrated" wrote in message ... I have a basic spreadsheet for my work that keeps track of sales for a promo that we have going on. I woulds like a formula that will tell me who is rank 1, 2, 3, 4,....so on. I have it so the final number in each category is a percent and would like to have a ranking that automatically adjust when the percentiles changes. thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do i make a sum formula ignore #div/0! errors in the range | Excel Worksheet Functions | |||
How do I set up excel to make estimating(pricing) easier? | Excel Discussion (Misc queries) | |||
IF & VLOOKUP FORMULA | Excel Worksheet Functions | |||
can i make a formula to search keywords in a excel workbook? | Excel Worksheet Functions | |||
Help with macro formula and variable | Excel Worksheet Functions |