Thread: Replace Cells with Column names in functions?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default Replace Cells with Column names in functions?
CustomerName is a defined name range for BT1204

Find & Replace

Find what: BT1204
Replace with: CustomerName


"msnyc07" wrote:

I have a # of fairly long/complex cell functions that get hard to debug
because there are also a lot of rows.

Is there anyway to change display so it replaces the column name e.g.

If(BT1204="X". BA="Y"

to

If(CustomerName="X", CustomerCode="Y")

?

Reply With QuoteReply With Quote