In Progress

Excel data anlysis

I have data on approximately 200 groups over 40 years. I have the data on 40 different excel sheets, and each spreadsheet lists all the groups for that particular year.

I want to know how these groups are changing over time in one specific criteria. The criteria is in a single column on each sheet.

The list groups do change slightly from year to year, as occasionally groups did not submit data.

So to analyse the criteria you must carefully cut and paste the columns from 40 sheets into one big sheet. There will probably be just over 200 rows, one for each group. There will be 40 columns, one for each year.

But you must be careful to make sure the right number goes in the right box, because the rows are not exactly the same each year. You cannot do a simple 'cut and paste'.

I have done the first four years as an example.

If this project goes well, and i have enough money, I will post two other projects looking at two other criteria

Skills: Data Entry, Data Processing, Excel

See more: excel data anlysis, how to make money from data entry, excel data sheet, data analyse, excel submit, excel 200, single data entry project, excel data analyse, time sheets excel, excel group list, excel group column, excel list example, sheet cut, example list excel, simple cut paste projects, project time sheet excel, excel script group data, excel data columns, example excel list, macro group data excel, excel column column, excel sheets data project, careful data entry, paste excel rows project, time sheet excel

About the Employer:
( 19 reviews ) Townsville, Australia

Project ID: #4349406

Awarded to:

aurora1974

Hi, I'm ready to start. Please check PM

$75 AUD in 3 days
(5 Reviews)
2.7

97 freelancers are bidding on average $93 for this job

FINGERRPRINT

we are interested in working in your project. Please check your inbox.

$400 AUD in 5 days
(121 Reviews)
7.1
Innovative116

Hi. I am interested in the project. Please check private message. Thank you

$95 AUD in 2 days
(83 Reviews)
6.9
hossionsumon

Dear sir,Experts team here do the project very fast [url removed, login to view] pm for [url removed, login to view]

$140 AUD in 3 days
(121 Reviews)
6.6
Wezigners

Hi, Ready to start your project work. Please provide those 40 files to me. Eagerly awaiting for your positive reply. Thanks, Jennifer.

$200 AUD in 5 days
(157 Reviews)
6.4
bdbangla

Hi, I can do this job in a professional manner. I can assure you to provide 100% accurate work. Please contact with me through private message. Thanks.

$75 AUD in 7 days
(95 Reviews)
5.9
ZeusMan

Looking forward to working with you...

$45 AUD in 2 days
(52 Reviews)
5.7
datasolutions6

Hi, Accuracy assured. Experienced here to get started right now. Please check your inbox for more details. Thanks

$90 AUD in 3 days
(44 Reviews)
5.7
koolsidz

Excel Whiz here ;) Please see PMB for more details

$55 AUD in 1 day
(86 Reviews)
5.6
nagybatonyi

Such jobs are my daily practice. In my approach you'll have opportunity to consult details with me, to test pilot solutions if necessary in order to achieve an optimal final solution. Further use of macros, fixing of b More

$100 AUD in 4 days
(40 Reviews)
5.4
mrbrave

Lets do it..

$50 AUD in 1 day
(68 Reviews)
5.3
inzaghi2006

Hi, I'm expert in parsing and extracting data from excel/csv files. Please contact me. Thanks

$40 AUD in 2 days
(24 Reviews)
5.0
nena88

Hi, I am reliable and hardworking with experience in data entry and Excel. I have reviewed your instructions plus the sample file and understand exactly what you need done. Please contact me and I can soon get started More

$85 AUD in 15 days
(16 Reviews)
4.6
LUretsky

I have 15 years of excel experience

$175 AUD in 3 days
(13 Reviews)
4.6
hemi

Hi, I am expert in excel. I am able to deliver satisfactory result as described within project description. Please see more details in private message.

$39 AUD in 1 day
(17 Reviews)
4.5
bluefox4ever

Dear Hiring Manager, I'm ready to start the project. I have read and understood the job description. Please read PM for bid details. Regards, Oliver

$100 AUD in 5 days
(12 Reviews)
4.3
DMediaDesign

Hi, I have experience with excel and programming projects, I'm ready to start.

$30 AUD in 1 day
(13 Reviews)
4.2
Nevergivesup

plz check pm

$30 AUD in 1 day
(11 Reviews)
4.1
Ohuma

I am a competent statistician. Please see PMB for details

$250 AUD in 3 days
(5 Reviews)
4.1
iit2009013

Hi there! I can complete the data of the excel sheet for all 200 groups and 40 years accurately. The attached excel file has only one sheet. Please share the complete file. Thank you!

$49 AUD in 1 day
(10 Reviews)
4.0
Pichart

I am an excel developer. I am expert in Excel both excel standard and Vba coding. This kind of work we can use macro to manage it. I explain more in PM.

$50 AUD in 2 days
(14 Reviews)
4.0