| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Recording highest and lowest ranking
I have a ranking system for a range of products. They are automatically
ranked each day to show which sells the best and which sells the worst. In a product information sheet I have a cell which displays "Ranking" it takes the ranking from a look up table. But in two other cells I would like to record the highest a products rankign has ever been and the lowest it has ever been. So basically if the ranking is in cell A1, the value in cell A2 (the highest ever ranking) has to be If A1 < A2, then A2 = A1, but if A1A2 then A2 doesn't change. I need to do this for around 14 products. Is this possible? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sum (throw out highest and lowest) | Excel Worksheet Functions | |||
| Difference Between Highest And Lowest? | Excel Discussion (Misc queries) | |||
| Graph Highest to Lowest. | Excel Discussion (Misc queries) | |||
| Highest High and Lowest Low | Excel Discussion (Misc queries) | |||
| Sort from lowest to highest | Excel Worksheet Functions | |||
Threaded Mode
