Excel Programming


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


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)

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)

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)

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)

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)

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)

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)

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)

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)

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)

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)

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)

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)

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)

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)

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)

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)

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)

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)

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)