Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I'm Using OpenOffice and have a spreadsheet that uses multiple sheets for individuals sales throughout the year, and a coversheet with a summary that I'd like to display the #1 performers in each category. I've worked out how to display the highest figure, but what I need is a way to display the NAME of that specific sheet in the next column, so I know WHO it was that achieved that result, at a glance.

To find the numerical value, I'm using

=MAX(Name1.B21;Name2.B21;Name3.B21;Name4.B21)

Whereas cell B21 on each sheet contains their total result, and in A1 in each sheet is the salespersons name (as well as the actual name of the sheet, which I changed for confidentiality)

Please help!

share|improve this question
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.