Excel Programming

Cancelled

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: Copy Typing, Data Entry, Data Processing, Excel, Microsoft Access

See more: programming in excel 2013, excel add in programming, example letter job, c++ programming codes, c# programming codes, programming with excel, m programming, programming codes c++, safiqulislam67, FP&A, concatenate, excel weight, weight excel, codes excel, excel add rows based value, generate codes, excel contain, programming codes, data programming excel, excel 1000, excel programming job, excel concatenate, excel add rows, letter excel, generate letter excel data

Project ID: #5070250

35 freelancers are bidding on average $39 for this job

priyal1997

Hi Dear Please send me the file.. First I will do it. Then you can check and offer me the job ;-)) Thanks Priyal

$30 USD in 0 days
(72 Reviews)
5.5
deepbluetech

Hi, I am interested in the project and shall complete it using Excel macros within a day. Please confirm and provide the Excel file. Regards, Arul

$30 USD in 1 day
(87 Reviews)
5.4
elMancha

Hello there. I have high Excel and Visual Basic skills with great professionalism. I study electronics and computer engineering at Oporto university and I'm looking for work to fill the blanks on my schedule. I' More

$30 USD in 1 day
(27 Reviews)
4.6
expertcoder1vw

I'm an experienced Excel / Access / VBA / VB developer and can do this job for you. I can deliver an application that will take the Excel file as input and produce another Excel file as output with the calculations per More

$168 USD in 2 days
(13 Reviews)
4.5
Virtualworker50

Respected Sir, It would be pleasure for me to render my services to you for excel programming according to your given conditions. I assure you the quality and timely work (5 hours). Here below find my work experienc More

$35 USD in 1 day
(46 Reviews)
4.2
caabdul

Assalam o alaikum dear Safiqulislam, How are you? May I do this project for you right now? PLEASE GIVE ME EXCEL FILE AND HAVE SOLUTION IN 5 MINUTES. Thank you

$30 USD in 0 days
(12 Reviews)
3.9
kalietvw

Hello, I'm a veteran virtual worker and have done many Data Entry project in my past (See past reviews) and would be interested in working on this project with you. Also, can you provide a small sample of your file? More

$40 USD in 2 days
(17 Reviews)
3.8
SiroosJafary

Good day, CONSIDER IT IS DONE! I am expert. I teach excel. I can say there is no formula in excel that I cannot handle it. I've got lots of experiences in excel automating and conditional formatting. Here are the link More

$30 USD in 0 days
(10 Reviews)
3.7
Midlander

Safiqul, I have made a spreadsheet using the Formula you need, but you made this a "restricted" project. Which means I cannot send the sample to you to let you judge my skill for yourself unless you send me a Private M More

$30 USD in 0 days
(4 Reviews)
3.6
zExcel

Hi, I'll be happy to set up the formulas or macro to accomplish that task. I am available to work on it now if I hear back from you within 1 hour

$30 USD in 1 day
(6 Reviews)
3.1
dviruki

Hi, I can do what you need. It's a pretty simple task and I can do it right now. I have 12 years of Excel experience.

$30 USD in 0 days
(5 Reviews)
2.6
GurpreetSngh220

hi, Ready to start work. We are highly interested to do your project work. Looking for long term relation ship. you can check my previous reviews here (for fast & accurate completion of projects) http://www.freel More

$55 USD in 1 day
(5 Reviews)
2.5
bmartynvw

I'm an expert developer with 18 years of experience. I can deliver the results you want to see, having read the project in detail.

$185 USD in 10 days
(3 Reviews)
2.4
soikaushik2013

Hi, I can do this project at ease. You will get a macro which can generate the required output. I am assuring you a time bound quality output. Regards

$35 USD in 1 day
(3 Reviews)
2.3
catalinconstanti

Hello, I am Excel expert, working for more than 13 years with formulas. Please let me know when may I start. Thanks & regards, Catalin

$30 USD in 1 day
(1 Review)
1.5
nvthuyne

Hello, As an experienced bioinformatician, I regularly have to perform such kind of transformations and compositions. I have already written an R-script that simulate your desired output on a small test dataset, and More

$30 USD in 1 day
(1 Review)
1.4
raman2012

HI safiq I read and understood your step 1 and step 2, Explain me the Step 3 I will deliver it in a day. regards Raman

$45 USD in 1 day
(1 Review)
1.3
mail2vimalarora

Hi.. I have completed requirement of code adding in the new column in spreadsheet. You can take a look at following image URL : http://s24.postimg.org/u5dledbh1/freelancer_vimalarora_safiqulislam67.jpg Waiting fo More

$30 USD in 0 days
(1 Review)
0.9
sethbarry

To Whom It May Concern: I've been a power Excel User for several years. I have come up with a formula based on your data that can create the code you are looking for using a single column. The results of the f More

$35 USD in 1 day
(1 Review)
0.6
idans

Hello Sir, I am sure i can do this. I am expert with advanced excel megaformula and VBA. Regards.

$72 USD in 3 days
(1 Review)
0.3