LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default Maximum value from multiple worksheets

rmc5446 wrote in message ...
this may seem too obvious but why not create a summary page that has all
the rows from your 25 worksheets and us the max function?



I have to activate the cells with the ten highest values and alter
them. It is possible that the ten highest values out of 2024 may all
be on the one worksheet. So I need a method to store all the values
(2024)and then activate the ten cells that contain the highest values.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Maximum Tabs/Worksheets in a workbook? cware Excel Discussion (Misc queries) 2 January 26th 09 07:59 PM
Is there a maximum of the number of worksheets in a workbook? CYNTHIA Excel Discussion (Misc queries) 6 December 18th 07 02:46 PM
Maximum number of Worksheets printed Charlotte Howard Excel Discussion (Misc queries) 2 December 19th 06 04:25 PM
Maximum number of worksheets in XL raju Excel Discussion (Misc queries) 6 November 17th 06 07:38 PM
maximum number of worksheets Shooter Excel Worksheet Functions 8 July 1st 06 06:38 AM


All times are GMT +1. The time now is 05:46 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"