Small function on Excel

€8-30 EUR

En cours

Publié

il y a presque 4 ans

€8-30 EUR

Payé lors de la livraison

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

N° de projet : 25768925

Concernant le projet

37 propositions

Projet à distance

Actif à il y a 4 ans

Cherchez-vous à gagner de l'argent ?

Adresse e-mail

Avantages de faire une offre sur Freelancer

Fixez votre budget et vos délais

Soyez payé pour votre travail

Surlignez votre proposition

Il est gratuit de s'inscrire et de faire des offres sur des travaux

Décerné à :

@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 en 1 jour

5,0

(6 commentaires)

4,0

37 freelances proposent en moyenne €16 EUR pour ce travail

@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 en 1 jour

5,0

(963 commentaires)

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 en 1 jour

4,9

(449 commentaires)

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 en 1 jour

4,9

(432 commentaires)

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 en 1 jour

4,7

(108 commentaires)

6,2

@writingapp

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

€10 EUR en 1 jour

4,9

(78 commentaires)

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 en 1 jour

4,6

(18 commentaires)

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 en 7 jours

4,0

(7 commentaires)

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 en 1 jour

5,0

(4 commentaires)

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 en 3 jours

5,0

(1 commentaire)

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 en 2 jours

0,0

(0 commentaires)

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 en 7 jours

0,0

(0 commentaires)

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 en 7 jours

0,0

(0 commentaires)

0,0

@dwivedidharmendr

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

€23 EUR en 1 jour

0,0

(0 commentaires)

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 en 7 jours

0,0

(0 commentaires)

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 en 7 jours

0,0

(0 commentaires)

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 en 1 jour

0,0

(0 commentaires)

0,0

@aimes2win

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

€23 EUR en 1 jour

0,0

(0 commentaires)

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 en 1 jour

0,0

(0 commentaires)

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 en 2 jours