Software

Ask something
Question Locked

Help With an Excel Formula

0 helpful
3 replies

by thomas.bowling

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have created a spreadsheet for our little league baseball stats. I have different worksheets for each team (18 worksheets for 18 teams). I am trying to set up one of the Worksheets to have the league leaders in each category (i.e. home runs, hits, strikeouts, etc.) Is there a possible way for a formula to pull this data automatically off the worksheets and put in on the league leaders worksheet? If there is could you plase let me know

3 replies

by sinecure

You can use the VLOOKUP command to pull data off of the other worksheets and calculate averages/totals/etc. on a main worksheet.

It would be hard to explain not knowing the fields (A2, E9, etc.) but if you use Excel Help on the topic VLOOKUP, it should point you in the right direction.

by absolutely

As long a batting average is always in column A, on all 18 worksheets, this will work brilliantly. in cell A1 of the League Leaders sheet:

=MAX(Sheet1!$A1:$A65535,Sheet2!$A1:$A65535,Sheet3!$A1:$A65535)

I could explain what the various pieces of punctuation are doing there, but I'll let you read the function first, and ask questions if you have any. Just win, baby!

This discussion is closed to new replies.