??Repot sheet name W/ A function on a different sheet??

N

n5jhx

Hello,
I have a question. What I'm working on is a budget, spending plan.
have a sheet for every month, named by the month. I also have a yea
end report sheet. On the year end report sheet I have a column name
"Maximum Spent Amount". I know how to tell excel to get the MAX amoun
from the months sheets, but I also want it to tell me what sheet th
MAX amount is on. Or month that it is in. I'm clueless here. Thanks i
advance.

N5JH
 

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

Top