Excel Programming

CANCELLED
Bids
37
Avg Bid (USD)
$43
Project Budget (USD)
$30 - $250

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 …

Skills required:
Copy Typing, Data Entry, Data Processing, Excel, Microsoft Access
Qualifications required:
us_eng_1 US English - Level 1
Hire safiqulislam67
Project posted by:
safiqulislam67 Bangladesh
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$ 30
in 0 days
$ 30
in 1 days
$ 30
in 1 days
$ 168
in 2 days
$ 35
in 1 days
$ 30
in 0 days
Hire kalietvw
$ 40
in 2 days
$ 30
in 0 days
$ 30
in 0 days
$ 30
in 1 days