Excel Programming

This project received 36 bids from talented freelancers with an average bid price of $43 USD.

Get free quotes for a project like this
Employer working
Project Budget
$30 - $250 USD
Total Bids
Project Description

have a spreadsheet containing approximately 1000 rows. I need to add a new column that contains some rules to automatically generate codes based on the values of other columns. The codes will look something like these: N18S22 N17C21 N18S23 N18S22 N16C20 The new column needs to generate these codes using the following rules: 1) Begin with the letter N. 2) Concatenate with the value from the "Size" column. 3) Concatenate with either an "S" or a "C", depending on the value in the "Color" column. If the color code value contains an "FP" anywhere in the code (eg., GNFP, FP, FPGN), concatenate with "S". If the color code does not contain an "FP", concatenate with "C". 4) Concatenate with the value from the "Weight" column and add 1. For example, if the value is "14", the concatenated value should be "15". Step 3 is the part that I'm not sure if Excel can do. You don't have to use Excel for this job as long as the delivered spreadsheet meets the above requirements. To …

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online