mode backwards?

[jackf-nc]

column b contains dates - sorted from oldest to newest. I am wanting to find most occuring date. I using mode(B:B) this does work / and doesnt. For example: in b:b I have 1/7 listed twice I also have 1/18 listed twice. In my case I want the LATEST date shown. Currently its just shows 1/7 because its the first occurrence

Any ideas?

[azumi]

Try to upload your example excel workbook for better understanding, if your data is sensitive,just make fake version

cheers

[jackf-nc]

Here is example as you requested... thanks again.

[jackf-nc]

using =INDEX(MODE.MULT(B2:B71),3) does give me the desired results for now, just dont know if this is best way to continue...Please advise.

[JohnTopley]

Try

=MAX(MODE.MULT($B$2:$B$71))

[jackf-nc]

Thanks John...Used it, but it took me back to 1/7. I need it to bring in the LAST(max?) mode point - in this case that would be 1/18? Any ideas?

[JohnTopley]

See latest updated post #5

[jackf-nc]

Think that did it! Would shake your hand! Thank you sir! Guess we will find out if she works, at NEXT mode point! damn, I hate ties!
Thanks again, friend!