Cell location = "Extract"?

  • Thread starter Thread starter Ken
  • Start date Start date
K

Ken

I used Advanced Filter to create a Unique records list
without a Header ... This worked fine.

Issue is ... the 1st cell in the unique records list
reflects Cell location as "Extract" ... the remaining
cells in the list reflect ... M31, M32, M33 etc.

I have tried Format Painter, over-typing, copy/paste
values only, Format Cell to no avail.

Above said ... How do I get data in Cell "M30" to
reflect "M30" location instead of "Extract"?

Thanks ... Kha
 
Excel creates a range name for you. Just like you would via Insert|Name|Define.

And you can get rid of it the same way--just Insert|Name|Define, click on
Extract and click Delete.

But you could still refer the cell as its address
=m30
and
=extract

will both return the same value.
 
Back
Top