Home |
Search |
Today's Posts |
#8
![]() |
|||
|
|||
![]()
On Thu, 26 May 2005 21:07:32 GMT, "John Galt"
wrote: Thanks. The 2nd formula worked out better for me. I made the necessary adjustments and voila! I appreciate your help! Glad to help. Be sure your years are sorted in ascending order or the MATCH function may not find the correct one. Also, any YEAR higher than the highest one in the table will return the last value. Thanks for the feedback. --ron |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Conditional Formatting Error | Excel Worksheet Functions | |||
How do i create a conditional sum? | Excel Worksheet Functions | |||
conditional formatting conflict? | Excel Worksheet Functions | |||
Determine cells that drive conditional formatting? | Excel Discussion (Misc queries) | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) |