Excel formula to retrieve value of a respective cell wid a max function on anothr cell

Originally Posted by martindwilson

thats a tad rude

More than a tad rude! If I'd noticed that post before I put my answer in, I'd probably not have bothered providing one at all!