| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Help displaying "Maximum" or "Minimum" if cell is max or min in a group?
Hi,
i am creating an excel spreadsheet for a class I am taking. I have a set of numbers (c2:c6), and my prof wants to have "Most Sales in Quarter" or "Fewest Sales in Quarter" displayed in the F column beside the number if it is either the maximum or minimum of the set. I've been at this for a while, and can't figure it out. Anyone help me out? EDIT: The Question is Display the words “Fewest Sales in Quarter” or “Most Sales in Quarter” next to the stores that have the fewest and most sales for that quarter, respectively. Be careful when to use absolute and when to use relative addressing in the formula! Last edited by RussAllison : February 23rd 11 at 09:34 PM |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
| HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
| Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
| Complex if test program possible? If "value" "value", paste "value" in another cell? | Excel Discussion (Misc queries) | |||
Threaded Mode
