Formula to define non-contiguous range?
Hi,
Please explain what you are trying to do.
--
If this helps, please click the Yes button.
Cheers,
Shane Devenshire
"Paul Martin" wrote:
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
|