Maximum value in a workbook

[brshm]

Please help to find out the maximum value corresponding to a cell value in a worksheet.

[dominicb]

Good morning brshm

Can you not use the MAX function thus:

=MAX(A1:Z1000)

will return the highest value in a range. If you need to know where it is you will need to use VBA. I can post the code here if you require. Alternatively I have an add-in available free of charge to anyone who requests it that will do this for you. To get this please feel free to e-mail me on [email protected].

HTH

DominicB

[brshm]

Actually I require the formula so that I get the max value in the entire workbook for a cell reference in the first worksheet which contains a list of items and the subsequent sheets contain monthwise data.

[dominicb]

Hi Brshm

Say you have 5 worksheets, named Shheet1,2,3,4 and 5.
The formula below will find the highest value in cell A1 in each of those sheets.

=MAX(Sheet1:Sheet5!A1)

Is that what you wanted?

HTH

DominicB

[brshm]

Let me explain the problem.
1st sheet contains a list of legal court case numbers and their details.
The following sheets contain the court hearing dates of these court cases, one worksheet corresponding to one month. Each month the dates for a particular case may come more than once.
I need to prepare a report which shows all the court cases alongwith their latest date of hearing taken automatically from the various monthly worksheets.

Hope that explains the problem. Thanks for taking interest in the problem.

[Bernard Liengme]

This sounds like a question for the programming newsgroup
NOTE: do not put Re in subject line since this makes your message look like
an answer rather than a question

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"brshm" <[email protected]> wrote in message
news:[email protected]...
>
> Let me explain the problem.
> 1st sheet contains a list of legal court case numbers and their
> details.
> The following sheets contain the court hearing dates of these court
> cases, one worksheet corresponding to one month. Each month the dates
> for a particular case may come more than once.
> I need to prepare a report which shows all the court cases alongwith
> their latest date of hearing taken automatically from the various
> monthly worksheets.
>
> Hope that explains the problem. Thanks for taking interest in the
> problem.
>
>
> --
> brshm
> ------------------------------------------------------------------------
> brshm's Profile:
> http://www.excelforum.com/member.php...o&userid=23509
> View this thread: http://www.excelforum.com/showthread...hreadid=372174
>