Results 1 to 3 of 3

Recode string into number on condition

Threaded View

  1. #1
    Registered User
    Join Date
    09-15-2010
    Location
    Hull, England
    MS-Off Ver
    Excel 2007
    Posts
    51

    Recode string into number on condition

    Hi.
    I have an enormous file of data in one column, which includes 4 words: 'increase', 'decrease', 'bought', 'sold'.
    How to recode automatically this values, so for each 'increase' or 'bought' i will get value of 1, and for each 'decrease' or 'sold' value 0.
    Please find attached.
    Thank you,
    AGA
    Attached Files Attached Files
    Last edited by AGA; 12-08-2010 at 02:09 PM. Reason: solved

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