| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with adding pages
I have a fomula [=MAX('Enter-Exit Page:9'!J59)] that gives me the MAX value of the values in Cell
J59 in each sheet in a workbook. The formula aboves works great up until page 9, but if there is 20 pages and i have page 10 active, i ONLY get the MAX value up until page 10 and it will not include pages 11-20. Is there a LAST PAGE formula or some way i can change the formula to show the Max value of ALL values in ALL sheets in J59 ? Hope i am explaining it correctly. Corey.... |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Help with adding pages
Forgot to mention.
The ENTER-EXIT PAGE is the name of page 1. "Corey" wrote in message ... I have a fomula [=MAX('Enter-Exit Page:9'!J59)] that gives me the MAX value of the values in Cell J59 in each sheet in a workbook. The formula aboves works great up until page 9, but if there is 20 pages and i have page 10 active, i ONLY get the MAX value up until page 10 and it will not include pages 11-20. Is there a LAST PAGE formula or some way i can change the formula to show the Max value of ALL values in ALL sheets in J59 ? Hope i am explaining it correctly. Corey.... |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Help with adding pages
Hi Corey
Create 2 dummy sheets and call them First and Last. Drag them so that they "Sandwich" the set of your sheets then use the formula =MAX(First:Last!J59) -- Regards Roger Govier "Corey" wrote in message ... Forgot to mention. The ENTER-EXIT PAGE is the name of page 1. "Corey" wrote in message ... I have a fomula [=MAX('Enter-Exit Page:9'!J59)] that gives me the MAX value of the values in Cell J59 in each sheet in a workbook. The formula aboves works great up until page 9, but if there is 20 pages and i have page 10 active, i ONLY get the MAX value up until page 10 and it will not include pages 11-20. Is there a LAST PAGE formula or some way i can change the formula to show the Max value of ALL values in ALL sheets in J59 ? Hope i am explaining it correctly. Corey.... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I delete pages in Excel? Keeps printing blank pages at end. | Charts and Charting in Excel | |||
| Need Help -- Baseball stats in excel only has 23 pages--Need to addmore pages.. | Setting up and Configuration of Excel | |||
| Adding Numbers From Web Pages | Excel Discussion (Misc queries) | |||
| adding row headings to multiple pages - how do i input the rows? | New Users to Excel | |||
| How do I delete pages from an Excell template of mutiple pages | Excel Discussion (Misc queries) | |||
Linear Mode
