applying formula to multiple worksheets

[mario]

I need to use the "Large" function to select the largest figure from a number of worksheets. The comparison number is in the same cell for each worksheet. How can I do this? Thanks.

 

[Jay Petrulis]

On 2002-04-12 08:24, mario wrote:
I need to use the "Large" function to select the largest figure from a number of worksheets. The comparison number is in the same cell for each worksheet. How can I do this? Thanks.

For the largest figure you can also use MAX

=MAX(Sheet1:Sheet3!B3:B4)
=LARGE(Sheet1:Sheet3!B3:B4,1)

Each will return the largest value in the range B3:B4 from sheets 1 through 3.

HTH,
Jay
This message was edited by Jay Petrulis on 2002-04-12 08:44

 

[mario]

You are the man!


On 2002-04-12 08:43, Jay Petrulis wrote:

On 2002-04-12 08:24, mario wrote:
I need to use the "Large" function to select the largest figure from a number of worksheets. The comparison number is in the same cell for each worksheet. How can I do this? Thanks.

For the largest figure you can also use MAX

=MAX(Sheet1:Sheet3!B3:B4)
=LARGE(Sheet1:Sheet3!B3:B4,1)

Each will return the largest value in the range B3:B4 from sheets 1 through 3.

HTH,
Jay
This message was edited by Jay Petrulis on 2002-04-12 08:44
[/quote]