Thanks:  0
Likes:  0

# Thread: applying formula to multiple worksheets

1. 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.

2. 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 ]

3. 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]

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•