Range limited by a wildcard
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,
|