Results 1 to 4 of 4

How to turn number to state

Threaded View

  1. #1
    Registered User
    Join Date
    11-14-2013
    Location
    Tromsų, Norway
    MS-Off Ver
    Excel 2010
    Posts
    13

    How to turn number to state

    I have a spreadsheet with a column that contains a value for number of burnt items in a specific coordinate and a column for number of items total in that coordinate. Each row repeats the exact amount of times as there are items in the total number column. What I want to do now is to make one column that has the value 1 or 0 dependent on whether or not a specific item is burned or not. The same goes for unburnt items. Se attached woorkbook.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 01-10-2013, 12:29 AM
  2. Replies: 2
    Last Post: 07-08-2012, 12:42 PM
  3. [SOLVED] Can VB Save hidden/grouped columns state, unhide all, then restore columns to saved state
    By JTwrk in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-27-2012, 02:54 PM
  4. How to populate city/state based on telephone number
    By coastieshak in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 01-12-2011, 03:25 PM
  5. auto fill state and city from phone number?
    By Biz in forum Excel General
    Replies: 2
    Last Post: 11-18-2005, 02:52 PM

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