Return a Value between dates based on another Value
I have several thousand rows
Any formula solution for that many rows will be slow to calculate. Have you
considered using a filter?
--
Biff
Microsoft Excel MVP
"casey" wrote in message
...
Sample data:
ColA ColB ColC
Row1 22 1/16/2009 55
Row2 23 1/18/2009 17
Row3 22 1/20/2009 33
Row4 25 1/23/2009 9
I have several thousand rows with every column a named range, i.e. rng1,
rng2, etc.
Example: I want to return '55' and '33' from ColC, based on '22' from ColA
between the dates 1/1/2009 and 1/31/2009 (ColB).
Thx,
casey
|