Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]() I need to run a formula that would do this on an active cell: =MIN(DATEVALUE(SUBSTITUTE('408134.xls'!K10:K11,"." ,"/"))) But instead of delimiting the range from K10:K11, I would like the formula to evaluate the column K with a range defined within two wildcards *, located in column B. The upper range would be * The lower range would also be * This would be continuous, therefore the formula needs to go the next range delimited by two wildcards * Regards, |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
create range bar graph | Charts and Charting in Excel | |||
Dynamic Print Range Help | Excel Worksheet Functions | |||
Define a range based on another named range | Excel Worksheet Functions | |||
named range refers to: in a chart | Excel Discussion (Misc queries) | |||
range name | Excel Worksheet Functions |