Find Jobs
Hire Freelancers

Excel expertise

$30-250 USD

Cancelled
Posted over 7 years ago

$30-250 USD

Paid on delivery
Finance Description of requirements/functionality: We need an excel file with the following behaviour. In the file there will be multiple data columns divided in two groups where: 1. Group 1: Column A & B are correlated data such as Text/Figure 2. Group 2:Column C & D & E & F & G are correlated data such as Text/Figure/Figure/Figure The number of rows can be from 1 to n, and the data from A & C can have some coincident values. The idea would be to move the data form group 1 (A & C) in such a way that A & C are in the same row. Example: A B C D E F G Text1 1 Text2 1 1 2 8 Text2 8 Text3 1 2 2 1 Text4 6 Text1 2 2 2 3 Text3 2 Text4 3 3 2 1 Then after clicking in a button it should be reorganised as such: A B C D E F G Text2 8 Text2 1 1 2 8 Text3 2 Text3 1 2 2 1 Text1 1 Text1 2 2 2 1 Text4 6 Text4 3 3 2 6 The data to analysed can start from the 4th row, however as this can change in the future we will need instructions about what we will need to change if the data would need to start from the 5th row or the 6th… and what we would need to change the columns that would be moved. For example, if we would add a third column in the Group 1. In addition, we will need the file to compare the amounts from B & G and if they are not the same, it should create separate file with name “{yyyymmdd}_Errors Reconciliation” in a folder called “Errors” and a message coming up saying “There are some accounts that are not reconciled”. In the file there would be a sheet called Balances with information from the Group 1. Apart from that we need the system to check if there is any data in C missing in A and in the other way around. Then in the file that the system created before it will add another sheet called “Missing Account” and two columns “In A from C” (if there is any data in column A missing from C, example, Text2 is missing in Column A but not in C) and “In C from A” (If there is any data in Column C missing from A, example, Text4 is missing in Column C but not in A)
Project ID: 11532555

About the project

7 proposals
Remote project
Active 8 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
7 freelancers are bidding on average $153 USD for this job
User Avatar
Hi, Accounting, Finance & MS Excel expert here I've read the project description, I can deliver it as per requirement Feel free to award Thanks
$99 USD in 3 days
4.9 (27 reviews)
4.8
4.8
User Avatar
Dear Sir/Madam, I have 3 years of experience in Excel VBA programming. I work as a data analyst Ford Motor Company creating automated reconciliations and reports on car sales figures of 21 European countries. Your requirements are pretty straightforward. I would recommend a textbox next to button where you can insert the number of the row where the matching should start. If it's empty then all rows are considered. Regards, Balint
$150 USD in 3 days
4.8 (3 reviews)
3.3
3.3
User Avatar
Dear client, Thanks for your attention. I am android and iOS app, web server developer. I will like to work on your project and deliver the project. I have developed many applications involving various functionalities GPS, Photo and Video App, Getting/Uploading data from server(JSON), Google api, Facebook api , Messaging, News and many other implementations. I’ve carefully gone through your job description and so I am very interested in your project. "Correct implementation for requirements + Fast Speed + Top Quality + Time". This is my working style. As a senior iOS and android app developer with more than 5 years experience, I have confident to complete this within specified time. I can satisfy all of your requirement and make it what you want in real. We can discuss other details on chat. Kindly give me opportunity to demonstrate it. Thanks. Project Estimation and Schedule to complete this project 1. Requirement analysis 2 . Each UI design and UI configuration 3. After completed , it will be delivery. 4. The implementation of app's function 5. Bug fixing and Testing 6. Deliver with well written source code
$155 USD in 3 days
5.0 (2 reviews)
2.5
2.5
User Avatar
I am an ACCA member having more than three years of hand on experience at Excell and different softwares too.
$155 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
We have read your project Requirements and are keen on working on your Project We can send you samples of similar work done in past for your evaluation of our skills. We have in depth knowledge of working in MS OFFICE ( WORD EXCEL POWER POINT) VISIO, Adobe Photoshop Adobe Acrobat Professional , Adobe Flash, Adobe Illustrator , Indesign and Corel Draw We assure you that we will execute the work as per your specifications We will be grateful to you if you could give us the opportunity to work with you on this project Regards, Sudha
$250 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$277 USD in 10 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of PAKISTAN
Rawalpindi, Pakistan
4.5
72
Payment method verified
Member since Jul 15, 2016

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.