Devam Ediyor

"category" from one column and number from next column to calulate a single number

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"

Else, "error"

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

Else, error.

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).

Beceriler: Excel

Daha fazlasını görün: amex, Column, import category, time card excel, assign category excel, job card excel, receipts excel, excel job card, generating receipts, gift green, project next number excel, job data import excel, import column, export excel columns, export excel column, jsf database table column number, import export excel, javascript table variable column number, jsf variable table column number, joomla category list remove number, assign project number, javascript form column number total, rows excel 1000, project due excel, import excel project error

İşveren Hakkında:
( 3 değerlendirme ) Havertown, United States

Proje NO: #6511312

Seçilen:

kher78

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 fazlası

0 gün içinde 45$ USD
(7 Değerlendirme)
3.3

19 freelancer bu iş için ortalamada 105$ teklif veriyor

zExcel

A proposal has not yet been provided

1 gün içinde 100$ USD
(105 Değerlendirme)
6.4
dpune

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 fazlası

in 3 gün içinde100$ USD
(39 Değerlendirme)
5.4
shikhamehta

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 fazlası

1 gün içinde 45$ USD
(51 Değerlendirme)
5.2
MimiFL

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 fazlası

in 0 gün içinde35$ USD
(43 Değerlendirme)
4.8
abdolah2014

hi I am an excel-vba Expert and I can finish your project so fast pm me ...........................................................................

in 3 gün içinde111$ USD
(22 Değerlendirme)
4.7
dragos1910d

Propunerea nu a fost încă furnizată

1 gün içinde 100$ USD
(30 Değerlendirme)
4.4
saravanan87

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

1 gün içinde 80$ USD
(37 Değerlendirme)
4.1
stevephillpott

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 fazlası

in 3 gün içinde100$ USD
(1 Değerlendirme)
3.4
Frileser

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 fazlası

1 gün içinde 111$ USD
(2 Değerlendirme)
3.2
excelmacro

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

in 3 gün içinde60$ USD
(3 Değerlendirme)
2.8
dank111

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 fazlası

1 gün içinde 100$ USD
(6 Değerlendirme)
2.6
cracken

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 fazlası

in 4 gün içinde250$ USD
(1 Değerlendirme)
1.1
bradyj87

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.

in 2 gün içinde66$ USD
(0 Değerlendirme)
0.0
cmstewart86

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 fazlası

in 3 gün içinde66$ USD
(0 Değerlendirme)
0.0
pravingiradkar

I am industrial professional .. Working with wide data in excel... I would like to go for this project..which

in 3 gün içinde155$ USD
(0 Değerlendirme)
0.0
asadmathour

A proposal has not yet been provided

in 3 gün içinde155$ USD
(0 Değerlendirme)
0.0
meredithpetrie

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 fazlası

in 3 gün içinde155$ USD
(0 Değerlendirme)
0.0
akibur

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.

in 3 gün içinde155$ USD
(0 Değerlendirme)
0.0