Results 1 to 6 of 6

Condition based replacements of Cells with other values

Threaded View

  1. #2
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,535

    Re: Condition based replacements of Cells with other values

    Not sure why you need to replace - could not just reverse the logic of your summary calcs ?

    If you need to replace then it would be best to first run an Edit -> Replace for each value (1 to 5 [ignoring 3]) replacing the digit with a separate character: eg 1 to @ and 2 to ^ etc...

    Once complete run a subsequent Edit -> Replace for each value converting @ to 5, ^ to 4 etc...

    (avoid using *, ~, ? characters)
    Last edited by DonkeyOte; 09-30-2010 at 04:55 PM. Reason: edit: revised based on wildcards !

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