Home |
Search |
Today's Posts |
#1
|
|||
|
|||
build up an array using formulas
I want to see in a variable range (A) if a certain value occurs.
The first and the last cell of range A are determined by other values. For example In col 1 I got dates from 01/01/2005 till 31/12/2005 (DD/MM/YYYY) In col 2 I got values like "CC", "VV", ... or nothing In col 4 till 7 I got something like this from till 0 01 January 2005 08 January 2005 1 09 January 2005 05 February 2005 In col 7 I would like to find the cell in col 2 where the value = "CC" within the range defined by the from and till fields. The value "CC" may normally only occur once in this range. So I would need a function or something that translates the "from - till" fields in a range of col 2 and than look for the value "CC" in this range and return the date from col 1 on this row. Can someone help me out ? I already tried several combinations on match, index, lookup, ... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
build up an array using formulas | Excel Discussion (Misc queries) | |||
Array formulas | Excel Worksheet Functions | |||
Problem with Array Formulas and ISNUMBER | Excel Worksheet Functions | |||
sumif and array formulas | Excel Worksheet Functions | |||
Using wild card characters in array formulas | Excel Worksheet Functions |