I am going to have a set of data (6 columns x approx. 1000 rows, and would like to do more in the coming months) import into Excel from a program called Neat Receipts. I do not have all of the data, the 6 columns x 1000 rows read yet for this export, though I can export what I have for the time being. I am hoping that this job will not be impeded or impacted due to the data not all being ready.
We are going to be generating 3 more columns of data.
First, read the number in column E.
If the value is $350-850, then it should assign a "1"
If the value is $850.01-1350, it should assign a "2"
If the value is $1350.01-1850, it should assign a "3"
If the value is $1850.01-2350, it should assign a "4"
If the value is $2350.01-2850, it should assign a "5"
If the value is $2850.01-3350, it should assign a "6"
If the value is $3350.01-3850, it should assign a "7"
If the value is $3850.01-4350, it should assign a "8"
If the value is $4350.01-4850, it should assign a "9"
If the value is $4850.01-5350, it should assign a "10"
If the value is $5350.01-5850, it should assign a "11"
If the value is $5850.01-6350, it should assign a "12"
If the value is $6350.01-6850, it should assign a "13"
If the value is $6850.01-7350, it should assign a "14"
If the value is $7350.01-7850, it should assign a "15"
If the value is $7850.01-8350, it should assign a "16"
If the value is $8350.01-8850, it should assign a "17"
If the value is $8850.01-9350, it should assign a "18"
If the value is $9350.01-9850, it should assign a "19"
All of this data will go into column G (although technically, I don’t need to see the column G data. I just feel that describing the project this way makes it more clear).
Next, read column D
If "Green Dot" then 4.95
If "Gift Card" then 5.95
If "vanilla reload" then 3.95
If Amex Campus Edition, then 4.95
If "Reloadit" then 3.95
If "OV" then 4.95
All of this data will go into column H (although technically, I don’t need to see the column H data. I just feel that describing the project this way makes it more clear).
Hello, I think I understand what you're looking to do and I don't need you to have the full blown data set. I will have some questions on what you're looking at doing (if anything) with the data in columns A-C & F (yo Daha Fazla
19 freelancers are bidding on average $105 for this job
Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 210 projects. Please look at the feedback left by my employers to know more about my work. Waiting for your positive Daha Fazla
Hey, I can make a spreadsheet template in which you would be able to import the raw data and click a button to run the ctaegorization logic that you have shared in the bid. It will also allow you to modify the ranges i Daha Fazla
Hi, i m serious freelancer with 100% completion rate and i believe i can do this project for you. If you are interested please provide me an example file, and i will try to create demo for you that will work with unlim Daha Fazla
hi I am an excel-vba Expert and I can finish your project so fast pm me ...........................................................................
I can do this work, its easy work for me, I would give you 100% accurate document with in 24 hours, please consider me to start this work. Waiting for your Positive response
I believe in demonstrating ability rather than posting a bunch of words in a bid. The excel document in this dropbox link will show how I would solve this problem: [url removed, login to view] Daha Fazla
hi I'm confidant that i can do it very quickly you can see some of my recorded excels here [url removed, login to view] please do look at "string manipulation" which shows creating new columns Daha Fazla
Hello, If you select me I'' create the solution in VBA. If you are interested I'll create a free demo for your consideration, before your final decision.. Best regards
Hi, My name is Dan. I am an expert in excel and all advanced functionalities. I have understood the logic of your calculation. We can do this in a very elegant way by creating a table of data ranges that you have gi Daha Fazla
Hi, Silverthunder. I am a well equip professional whose knowledgeable MS documents. Highly technical in experts in commandline Terminal command. By the way, let me introduce myself. I am a professional and experience Daha Fazla
I have worked with Excel at my current job for 3 years and I develop custom formulas and custom process to make things more accurate and timely. This sounds like a fun project.
This project sounds straightforward. As part of my day to day job I routinely manipulate spreadsheets involving large sets of data and complex calculations. I also have experience in using Excel VBA which has proven Daha Fazla
I am industrial professional .. Working with wide data in excel... I would like to go for this project..which
I have extensive Excel skills, included 1000's of rows and hundreds of columns of data that I've organized and exported during both my Masters and PhD work in the physical sciences. I am especially skilled in IF_T Daha Fazla
i have lots of experience in this field. so i can grantee u some good output. I can do the job for less money if u want.