I know this is probably very simple but up to now I've spent an hour trying to find out how to do it. All I need is a formula / method of displaying in a cell the MAX from non adjacent cells.
I thank you for your help.
I know this is probably very simple but up to now I've spent an hour trying to find out how to do it. All I need is a formula / method of displaying in a cell the MAX from non adjacent cells.
I thank you for your help.
Something like:
=MAX(B3,D5,F5,H7,H10,F12)
Regards
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks