LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Roger H.
 
Posts: n/a
Default Finding Maximum

Hello. Thanks for considering my post.

I have several thousand numbers in column A.In column B, I am using the
Match function to locate the next occurrence of each number in A.No
problem.What I need now is some advanced formula manipulations to find the
Maximum of the series for *each* number that is returned by Match.I want
each Maximum in an individual cell.
In column C, I will simply put a series of numbers starting with 1 and
ending with 333.In column D, I want the maximum returned by Match in B for
*each* number in C.
Thank you.


 
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
find which column has the maximum value Frank Drost Excel Discussion (Misc queries) 2 December 15th 05 01:09 AM
Tricky 'Find Maximum' problem seeks formula tx12345 Excel Worksheet Functions 6 December 5th 05 10:26 PM
Finding the maximum of a subset of values on a different sheet rmellison Excel Discussion (Misc queries) 4 December 1st 05 03:56 PM
Scroll Bar maximum value Lee Charts and Charting in Excel 4 April 2nd 05 05:22 AM
finding the coordinates of the maximum point on a graph eastham85 Charts and Charting in Excel 2 January 16th 05 01:34 PM


All times are GMT +1. The time now is 02:15 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"