I've got a cell that contains a MAX or MIN function. I would like to use a list to chose which of them to use in a particular instance, but it's not immediately obvious to me how to do this - or if it's even possible. Any ideas on this?
I've got a cell that contains a MAX or MIN function. I would like to use a list to chose which of them to use in a particular instance, but it's not immediately obvious to me how to do this - or if it's even possible. Any ideas on this?
Those of you who think you know everything are annoying to those of us who do!
Why don't you use a helper column?
Use Data Validation to chose Min or Max
then the formula in your cell is quite Simple =if(A1="Min", Min(B20:B40), Max(B20:B40))
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
That will work, thanks! I've got an IF in there already, so now I'm nested IF territory - which typically confuses me MAX!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks