Add and fix on formula to extract more data columns for a exiting Formulated excel [login to view URL] Excel Formulas skill needed

Closed Posted 4 years ago Paid on delivery
Closed Paid on delivery

Add and fix on formula to extract more data columns for a exiting Formulated excel spreadsheet.

Data to be extract from PDF to excel ,

1. Add on formula to extract more data columns for a exiting Formulated excel spreadsheet

2. Fix on the formula to extract correctly and in sequent

3. Add on Tab to summarize and organize the data for easy reference

1 Attached sample PDF

-It is merge from 15 Different PDF files

-Each PDF file represent a set of data base of a property titles

2) Attached sample excel file with 4 tabs are created

a) Raw ‘Tab” Column A and B consist of the copied merge PDF data

b) Report “ Tab” supposed to extract the data of needed ,

Those highlight in red represent wrong data extract and formula needed to fix ,

those highlight in yellow represents Add on formula to extract more data columns for a exiting Formulated excel spreadsheet

c) data extract “tab” to be populate with the data extracted

d) Rules column ( was set by the previous freelancer , got no idea what is for ? )

Data Entry Data Processing Excel Software Architecture Visual Basic

Project ID: #20075423

About the project

14 proposals Remote project Active 4 years ago

14 freelancers are bidding on average $165 for this job

dvcontact

Hi, You won’t make the right candidate selection without knowing what your project on adding and fixing formulas in an Excel spreadsheet for extract data from PDF files will look like. Fortunately, I can show you how y More

$150 SGD in 2 days
(59 Reviews)
6.5
leemilun

Hello there, I have gone through your project detail. And the attached files. Surely I can help you. I feel confidence all the skills you required. I will do my best to satisfy you. Let's have a quick chat to discuss More

$300 SGD in 3 days
(59 Reviews)
6.6
kipdev13

Nice to meet you. I've read the task description and can develop definitely. I'll provide you with the highly skill to complete this task in time. I'll also do my best for you. Please contact with me. Thank you ve More

$100 SGD in 3 days
(75 Reviews)
5.9
citijayamala

1. I am an expert in Excel, Excel formulas, and all excel functions, macros, lookup, pivot tables and charts. I read your project description and I am sure that I can handle your project. 2. Have done many projects i More

$150 SGD in 3 days
(73 Reviews)
5.8
hoisticdeveloper

Hi there I am excel expert, I can do this project and give you the best result. I can work on excel also on VB script if you want custom functionality. I can create maria if needed for your project. please contact me More

$555 SGD in 5 days
(9 Reviews)
4.9
designer504

My expertise in this field What we Expertise in: PowerPoint, EBOOKS, Digitise, LOGO, Prezi, Editable and Fillable PDF, 2D, EXPLAINER VIDEOS, ANIMATION, Indesign,Apps design, Infographics, Illustrations, Brochures, Fly More

$50 SGD in 1 day
(6 Reviews)
4.1
abbasJz

Dear employer, Hi I have done my M.Sc. thesis using Python and Excel. It was about developing a numerical model for simulating fluids flow through porous media. I developed the main code in Python and developed m More

$150 SGD in 3 days
(22 Reviews)
4.5
khaldalfalah

I have experience in MS SQL server and VB.net more than 12 years,and a good in Excel vba&macros ,I am ready to work with you. CV: I am software engineer, Holder of a degree in Faculty of Information Technology - Unive More

$250 SGD in 6 days
(12 Reviews)
3.6
montylc

Hi there , I have understood your requirement And i would be more than happy to assist you . lets connect and work

$140 SGD in 7 days
(1 Review)
3.2
winmaxtel

I can work safely at work I have worked in many marketplaces before,If your job is not good then your payment is refundable so there is no problem.

$30 SGD in 3 days
(0 Reviews)
0.0
rosemaryblock

I have been working in Excel for more than 10 years using macros and formulas! Having read your sample files I know I can do this project efficiently! I pride myself on bringing value to you and providing a completed More

$150 SGD in 3 days
(0 Reviews)
0.0