Dynamic Range Defined by Value of Cell
How do you intend to use this range?
A1:INDEX(A:C,MATCH("Total",A:A,0),3)
That will define the range but by itself that really doesn't do anything.
--
Biff
Microsoft Excel MVP
"Domenick" wrote in message
...
I am just getting started with dynamic ranges. I have data as follows:
A B C
Product1 qty cost
Product2 qty cost
...
ProductN qty cost
TOTAL qtytot costtot
The number of products varies. There is other data below this that is
unrelated. How can I define a range dynamically that will always capture
A:C
and as many rows up and including the first time it finds "TOTAL" in
column A?
Any help greatly appreciated.
Thank you.
|