Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi
I have a table with two columns, much like stock quotes. Column A holds the time in ascending order. Column B holds the values, which are pretty much at random, just like stock quotes. I want to find the first appearance of a certain value AFTER a certain time. The INDEX MATCH function does just that but I cannot get the time criteria in there. Here is what I do: =INDEX(A:A;MATCH(C1;IF(A:AC2;B:G);0)) A = time column (ascending order) B = value column (random order) C1 = value to look for C2 = time after which the values first appearance I want to know (not before that time) The whole thing kept me busy for a couple of days now, without any solution besides adding extra columns. That is not an option because I have a couple of hundred tables which waists to much of my time and data power. I would appreciate every thought on that. Thanks in advance. Michael EggHeadCafe - Software Developer Portal of Choice Build a C# SQL Server Database Export Utility http://www.eggheadcafe.com/tutorials...erver-dat.aspx |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
INDEX w. MATCH function | Excel Worksheet Functions | |||
Need help with function using INDEX and MATCH. | Excel Worksheet Functions | |||
Match and Index function | Excel Worksheet Functions | |||
index match array function-returning only first match, need last. | Excel Worksheet Functions | |||
Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions |