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!