MAX with condition

A

andrew

I have 10 worksheets, sandwiched between Start & End dummy sheets. Within
each of the 10 w'sheets, i have specific cells with formula to tabulate
certain sums.

There is a Summary page (in front of Start) which has a formula cell to
calculate the MAX value across the same cell in all 10 w'sheets. Within each
cell, i have A1 cell that has text title while C2 contains the cell to find
the max value.

I managed to grab the MAX value to display on the Summary page. However, i
have an additional criteria where assuming the MAX value came from Sheet
1(C2), is it also possible for the formula to 'grab' the text displayed in A1
(text title) to show on the Summary page?

I tried with this formula but doesn't work:
=IF(MAX(Start:End!C2),(MAX(Start:End!C2)=A1),"")

Any suggestions?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Multiple worksheets? 3
MAX across worksheet, return text value 8
Worksheet poser... 3
VBA Coding Help for Beginner 0
Max Length in a row 1
Space at end of multi page list to accommodate new entries 1
Max-Min with specific criteria 1
Newbie Help - IF Yes No Function 0

Top