+ Reply to Thread
Results 1 to 2 of 2

Min Max Editing

  1. #1
    bkj8890
    Guest

    Min Max Editing

    =MIN(F11,K11,P11,U11,Z11,AE11,AJ11,AO11,AT11,AY11,BD11,BI11,BN11,BS11,BX11,CC11,CH11,CM11)

    =MIN(F15,K15,P15,U15,Z15,AE15,AJ15,AO15,AT15,AY15,BD15,BI15,BN15,BS15,BX15,CC15,CH15,CM15)

    I would like to know if there is a way to change the numbers withour
    changing each one individually?The first line is a MIN that I selected by
    holding the Ctrl and picking each box. The second line, I picked the cell and
    pasted then changed the numbers only one at a time. If I know where the next
    line comes in at, can I just change the all the numbers at one time but keep
    the same formula?
    Thanks


  2. #2
    pdberger
    Guest

    RE: Min Max Editing

    BKJ --

    Click on the cell you want to change, and then press CTRL-H. Enter the
    string of characters you want to replace (11) and then the string you want to
    replace it with (15). Should do the trick, and works on a range of cells as
    well as just one.

    HTH

    "bkj8890" wrote:

    > =MIN(F11,K11,P11,U11,Z11,AE11,AJ11,AO11,AT11,AY11,BD11,BI11,BN11,BS11,BX11,CC11,CH11,CM11)
    >
    > =MIN(F15,K15,P15,U15,Z15,AE15,AJ15,AO15,AT15,AY15,BD15,BI15,BN15,BS15,BX15,CC15,CH15,CM15)
    >
    > I would like to know if there is a way to change the numbers withour
    > changing each one individually?The first line is a MIN that I selected by
    > holding the Ctrl and picking each box. The second line, I picked the cell and
    > pasted then changed the numbers only one at a time. If I know where the next
    > line comes in at, can I just change the all the numbers at one time but keep
    > the same formula?
    > Thanks
    >


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1