Small function on Excel

€8-30 EUR

Folyamatban

Kiadva ekkor:

majdnem 4 évvel ezelőtt

€8-30 EUR

Teljesítéskor fizetve

I just need to retrieve values from one table to another on the same excel file. This table is a list of clients to be dunned. The first table "2018" is the list of customers in 2018, and table "2019" is the list of customers to be dunned in 2019. What I want to do is to retrieve the comments from table 2018 to put them back in table 2019. Between table 2018 and 2019 there may be customers who no longer exist because they have regularized their situation, and new customers may appear because they are late in paying. Retrieving comments from one year to the next is just to retrieve the history of customer comments that are still present from one year to the next. The formula shown in cell G2 of table 2019 is a formula that should normally be the correct solution, but I don't understand why it doesn't work. So I need either the formula to be corrected or I need a solution that would allow me to get the desired result.

Excel

Projektazonosító: 25768925

A projektről

37 ajánlat

Távolról teljesíthető projekt

Aktiválva: 4 évvel ezelőtt

Szeretne pénzt keresni?

E-mail cím

A Freelancer oldalán történő árajánlatadás előnyei

Határozzon meg költségvetést és időkeretet

Kapja meg fizetését a munkáért

Vázolja ajánlatát

Ingyen regisztrálhat és adhat árajánlatot munkákra

Neki odaítélve:

@xcelinfinity

Hi there My name's Benne and I have helped thousands of people via Excel forums, training, and consultancy projects. i have done it for you. can also explain why yours didn't work

€8 EUR 1 napon belül

5,0

(6 értékelés)

4,0

37 szabadúszó adott átlagosan €16 EUR összegű árajánlatot erre a munkára

@cgullapalli

HI, I am good at Excel and formulas. I have referred the requirement. I can pull the value from one sheet to other. -Chandra

€8 EUR 1 napon belül

5,0

(963 értékelés)

8,1

@P0L

Hello, I can help you with your function. I have over 10 years of experience in Excel and VBA code. Let me know if you would like to discuss further.

€30 EUR 1 napon belül

4,9

(449 értékelés)

7,8

@TonmoyRoy111

Dear client, I have sound knowledge in Excel and I have previously carried out a number of projects in excel using macros and formulas. I ensure you will be happy after hiring me. Kindly contact me. Roy

€15 EUR 1 napon belül

4,9

(432 értékelés)

7,3

@daniyal3214

I can definitely help you with that. I am a professional Excel expert holding years of experience in utilizing advance level tools and functions of Excel (including VBA and Macro). I will be happy to discuss in detail how I am highly suitable for this project.

€19 EUR 1 napon belül

4,7

(108 értékelés)

6,2

@writingapp

Hi. I have written many automation Excel VBA macros. Ready to write your project. Will complete within 1 day

€10 EUR 1 napon belül

4,9

(78 értékelés)

5,7

@zaahidali61

Hi, I have gone through your attachment I can retrieve from one table to another as per your instruction. I am excel expert having 10+ years experience. I have completed similar project for different employers. Looking forward.

€10 EUR 1 napon belül

4,6

(18 értékelés)

4,6

@shish1992

Hello there.. , I'm a Data Scientist and mathematician. I am well versed with:  Algebra and analysis. I work on: Linear algebra  Statistics - Statistical modeling using R -Markdown report  Marching Learning using R -Predictive models - Models for classification and regression -  Macroeconomics and microeconomics -data analysis -data entry -Econometrics -SPSS -STATA  ANOVAs -time series -spatial regression  Probabilities  E-views Regards C.S

€30 EUR 7 napon belül

4,0

(7 értékelés)

3,7

@Mainaah

Dear Prospective Client, I am well versed with Excel and its various features like Pivot tables, HLookup, Vlookup, Countif, SUMIF, Left, Right, Index Match, Drop Down, Filters, Charts, Graphs, Conditional Formatting, Mail Merge, Dashboards and can Provide the Excel that you are looking for. I have more than 5 years of working experience to my credit. I will be happy to answer any queries that you may have. Looking forward to your positive response. Kindly ENGAGE me for more details.

€10 EUR 1 napon belül

5,0

(4 értékelés)

1,8

@triptisam1993

I can solve your issue to consolidate both the excel into a final excel file as per your requirement. I am an engineer having expertise in excel. Please message me to discuss in chat.

€20 EUR 3 napon belül

5,0

(1 értékelés)

0,4

@chcharan422

Hi, Greetings I have read your project placements and it matches with my expertise. I understand you are looking for a data entry expert. Who can convert pdf into word file with high accuracy. I'm a data entry expert with three years experience. I have also Microsoft office specialist certifications in MS Word, Excel and PowerPoint from Official Microsoft (Certiport). So I can handle you work very efficiently. I have experience of data entry for a US based project of a US Company "Charter Communications" I looking forward for you response. Thanks

€19 EUR 2 napon belül

0,0

(0 értékelés)

0,0

@balajikhare96

Dear Prospective Client Ready to START now with a sample for the accuracy and quality check. I will perform an accurate web search to collect the required details by following all your directions and instructions and input all those details into the excel spreadsheet as per your requirements within your targeted time. I will make sure to deliver 100% accurate results without any error. I will be available all the time for quick updates and follow-ups. I am a professional web researcher and data entry expert. I’ve been working on research, data entry and lead generation projects for the past 4 years, having good skills and knowledge. Looking forward to your quick positive response.

€20 EUR 7 napon belül

0,0

(0 értékelés)

0,0

@Innokia

I can handle this project with confidence, hope you will grant this project to me, So you won`t worry about this as I will do this to you in a given time frame & low budget.

€19 EUR 7 napon belül

0,0

(0 értékelés)

0,0

@dwivedidharmendr

I will do this work Relevant Skills and Experience I have experience i will do.

€23 EUR 1 napon belül

0,0

(0 értékelés)

0,0

@KHAN11519

i have five year experience relates your project please share with me your project detail i will send you after completion as soon as possible

€19 EUR 7 napon belül

0,0

(0 értékelés)

0,0

@Iccgaggoo

Yes i am full command on MS Excel work sheet. Excel Formulla easily apply for this sheet. I am ready to continue Excel work.

€19 EUR 7 napon belül

0,0

(0 értékelés)

0,0

@Ravishukla9599

I HAVE VAST EXPERIENCE IN THIS SO PLZ GIVE THIS PROJECT TO ME Relevant Skills and Experience EXCEL DATA ENTRY WORKED WITH TNT FEDEX DUE TO COVID 19 I HAVE LOST MY JOB

€23 EUR 1 napon belül

0,0

(0 értékelés)

0,0

@aimes2win

Needs can complete work on time Relevant Skills and Experience Gud skill way to work

€23 EUR 1 napon belül

0,0

(0 értékelés)

0,0

@ash58027370de646

I can do this task for you, I'm a professional Microsoft office expert with 6 years of experience. I'll sort your problem and I'm sure you'll be pleased with my work.

€14 EUR 1 napon belül

0,0

(0 értékelés)

0,0

@saziz82

I am telecommunications engineer having long experience working with excel, i can deliver this project quickly and accurately. Looking forward to working with you Sir/Madame. Thanks.

€19 EUR 2 napon belül