Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Removing Named Range from Formula

  1. #1
    New Member
    Join Date
    May 2002
    Location
    Maryland USA
    Posts
    32
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I have many rows of a formula in several hundred worksheets similar to:

    =If(q5="I",a1*b1,if(MED="P",a1*b2,a1*b3))
    where MED is a named range for column Q.

    The formula uses both a relative reference, i.e., Q5 and a named reference, i.e., MED to signify the same cell (don't ask me why

    I would like to remove the named range reference from the formula, and replace it with Q5 etc...

    Thank you!

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Newcastle, UK
    Posts
    1,174
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-05-09 07:19, JPBJR wrote:
    I have many rows of a formula in several hundred worksheets similar to:

    =If(q5="I",a1*b1,if(MED="P",a1*b2,a1*b3))
    where MED is a named range for column Q.

    The formula uses both a relative reference, i.e., Q5 and a named reference, i.e., MED to signify the same cell (don't ask me why

    I would like to remove the named range reference from the formula, and replace it with Q5 etc...

    Thank you!
    when you say named range, do you mean named cell?
    you said that MED refers to Column Q, which is not the same as Q5?


    You can use Find/Replace on formulas.

    Highlight the area you want

    press Ctrl+H
    in Find put MED
    in Replace put Q5
    Replace All or Alt+A

    If that's what you need.

    _________________
    Share the wealth!!
    Ian Mac

    [ This Message was edited by: Ian Mac on 2002-05-09 07:28 ]

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •