![]() |
#7
|
|||
|
|||
![]()
Mr. Macropod,
You are right, the value is 150.96515, but i just need the round up number. The matching logic to find the value is that the value should be below the peak. from my point of view (for the data and the graph), the value i want occurred several times (before the peak or max and after that) and the formula i use will pick the later. Is there anyway to limit the search up to the max value only, so that it will pick the value before the peak? The formula i want to write is general so that i can use it with any data i have. Your effort is much appreciated. Regards, Udea |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Multi-Variable Lookup help | ebolton | Excel | 8 | 05-05-2011 05:28 AM |
![]() |
lawnG | Word Tables | 1 | 01-31-2011 03:50 PM |
Creating Lookup in Excel | vikash kumar | Excel | 2 | 12-06-2010 06:50 AM |
![]() |
Grapejuice | Excel | 2 | 10-15-2008 02:02 PM |
Help with Max or lookup fomula to return a name forAmaxValue | dutch4fire23 | Excel | 0 | 07-28-2006 01:12 PM |