P
Paul Martin
Hi folks
Is it possible to use an Excel formula to define a non-contiguous
range? I have a column of data, let's say
A1: Mechanical Causes
A2: blah
A3: blah
A4: Mechanical Causes
A5: blah
A6: Mechanical Causes
I'd like to create a named range that uses a formula that identifies
the cells in a column that have a particular value - in this case
"Mechanical Causes". I suspect it's not possible, but thought I'd see
if anyone else has any ideas.
Thanks in advance
Paul Martin
Melbourne, Australia
Is it possible to use an Excel formula to define a non-contiguous
range? I have a column of data, let's say
A1: Mechanical Causes
A2: blah
A3: blah
A4: Mechanical Causes
A5: blah
A6: Mechanical Causes
I'd like to create a named range that uses a formula that identifies
the cells in a column that have a particular value - in this case
"Mechanical Causes". I suspect it's not possible, but thought I'd see
if anyone else has any ideas.
Thanks in advance
Paul Martin
Melbourne, Australia