Käynnissä

Two (Relatively) Simply Excel functions needed

Need help tweaking an Excel function to work with spreadsheet and coming up with an additional Excel function for same spreadsheet. This one should be quite simple and straightforward if you have sufficient experience with Excel functions (which I don't).

For the first function, I'm looking for a function that will compare the value in Column B for a row with all the values in the same column for the rows above as well as all the rows in that column (Column B) in two other worksheets and that will copy to Column A the contents of Column A for any match found.

For the second function, if the value in Column K matches a value in Column K on a different spreadsheet, the results will be copied to Columns M, P and Q.

Can send over sample spreadsheet to help explain things better.

Taidot: tietojenkäsittely, Excel

Näytä lisää: simply well, excel help needed, need help excel, excel compare two worksheets, excel function, compare spreadsheet, relatively simple function, excel row column, compare rows excel, excel additional, excel compare columns data, additional functions, excel column row, excel compare row, simply data excel, column row excel, excel match columns row, excel column copy, excel copy values, excel compare columns, excel data match, match columns excel, functions spreadsheet, sample data processing spreadsheet, simple excel functions

About the Employer:
( 11 reviews ) Chapel Hill, United States

Projektin tunnus: #4287859

Myönnetty käyttäjälle:

sasindiv

Hi, I have 8 years experience in programming. I have sent personal message to you with the detailed solution.

30 $ USD 2 päivässä
(1 arvostelu)
1.2

26 freelanceria on tarjonnut keskimäärin 36 $ tähän työhön

nagybatonyi

See your formulas in PMB! Regards

35 $ USD 0 päivässä
(38 arvostelua)
5.3
vbexcel

Excel pro, I can start on your project today.

40 $ USD 1 päivässä
(25 arvostelua)
5.2
ethicalboy

Thanks foe this project.

30 $ USD 0 päivässä
(26 arvostelua)
4.7
jal540

I have done many custom Excel projects and have excellent ratings.

40 $ USD 5 päivässä
(8 arvostelua)
4.1
mandeeps207

Hi there, Its me pleasure to finish this task for you. If interested pls reply asap..... regards

30 $ USD 1 päivässä
(17 arvostelua)
3.9
manishadk

I am Expert in Excel. Please check PMB for details.

30 $ USD 1 päivässä
(8 arvostelua)
3.5
abupabuya

//////////////SELL ITEMS////////////////

100 $ USD 1 päivässä
(4 arvostelua)
3.4
rfreelancer2008

Hi there - I am ready to start this asap, and am very much interested to work on this project with you. I am passionate to work on VBA projects and would like to get a chance to work on this one. more in pmb.

40 $ USD 2 päivässä
(9 arvostelua)
3.1
jaylancer43

Please check your PM..!!

30 $ USD 0 päivässä
(6 arvostelua)
2.9
seaanddream

very much inetersted with your project with excel functions... KR,

35 $ USD 1 päivässä
(5 arvostelua)
2.8
benefitworks

This is very easy. I can finish in few hours. Thanks karim

30 $ USD 1 päivässä
(3 arvostelua)
2.5
saravanan87

I am ready to start.. Please post the both excel sheet...

30 $ USD 1 päivässä
(1 arvostelu)
1.6
suriyant

With more than 10 years experience in Excel and VBA programming, I can do it immediately.

30 $ USD 0 päivässä
(1 arvostelu)
1.0
ranjanappa

Hi I am a MIS analyst making excel reporting from past 8 years i am very good with excel formulation and automation. i am interested in this project it sounds very interesting to me. i can work with accuracy and i have Lisää

30 $ USD 1 päivässä
(1 arvostelu)
0.0
krismani

Please se PM

30 $ USD 2 päivässä
(0 arvostelua)
0.0
sylvestermolina

Consider it done :D Ready to go.

30 $ USD 0 päivässä
(0 arvostelua)
0.0
shofi39

Dear Sir, I am well versed in accounting as well as excel and Quickbooks. Please consider me. Hope to hear from you soon. Shafikul Islam

50 $ USD 4 päivässä
(0 arvostelua)
0.0
krishnadubey

Hello, I'll be happy to create two excel function. Regards, Krishna

50 $ USD 1 päivässä
(0 arvostelua)
0.0
florinfota

I have the necessary skills to do this job - more than 20 years of experience in MSOffice

30 $ USD 2 päivässä
(0 arvostelua)
0.0
rizwan021

I can put the formula in your worksheet then and there!

30 $ USD 1 päivässä
(0 arvostelua)
0.0