Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
find which column has the maximum value | Excel Discussion (Misc queries) | |||
Tricky 'Find Maximum' problem seeks formula | Excel Worksheet Functions | |||
Finding the maximum of a subset of values on a different sheet | Excel Discussion (Misc queries) | |||
Scroll Bar maximum value | Charts and Charting in Excel | |||
finding the coordinates of the maximum point on a graph | Charts and Charting in Excel |