Tamamlanmış

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.

Beceriler: Veri İşleme, Excel

Daha fazlasını gör: 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

İşveren Hakkında:
( 11 değerlendirme ) Chapel Hill, United States

Proje NO: #4287859

Seçilen:

sasindiv

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

%selectedBids___i_period_sub_7% gün içinde 30%project_currencyDetails_sign_sub_9% %project_currencyDetails_code_sub_10%
(1 Yorum)
1.2

Bu iş için 26 freelancer ortalamada $36 teklif veriyor

nagybatonyi

See your formulas in PMB! Regards

in %bids___i_period_sub_35% gün içinde35%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(38 Değerlendirme)
5.3
vbexcel

Excel pro, I can start on your project today.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(25 Değerlendirme)
5.2
ethicalboy

Thanks foe this project.

in %bids___i_period_sub_35% gün içinde30%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(26 Değerlendirme)
4.7
jal540

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

in %bids___i_period_sub_35% gün içinde40%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(8 Değerlendirme)
4.1
mandeeps207

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(17 Değerlendirme)
3.9
manishadk

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(8 Değerlendirme)
3.5
abupabuya

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(4 Değerlendirme)
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.

in %bids___i_period_sub_35% gün içinde40%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(9 Değerlendirme)
3.1
jaylancer43

Please check your PM..!!

in %bids___i_period_sub_35% gün içinde30%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(6 Değerlendirme)
2.9
seaanddream

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(5 Değerlendirme)
2.8
benefitworks

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(3 Değerlendirme)
2.5
saravanan87

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(1 Yorum)
1.6
suriyant

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

in %bids___i_period_sub_35% gün içinde30%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(1 Yorum)
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(1 Yorum)
0.0
krismani

Please se PM

in %bids___i_period_sub_35% gün içinde30%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
0.0
sylvestermolina

Consider it done :D Ready to go.

in %bids___i_period_sub_35% gün içinde30%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
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

in %bids___i_period_sub_35% gün içinde50%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
0.0
krishnadubey

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0
florinfota

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

in %bids___i_period_sub_35% gün içinde30%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
0.0
rizwan021

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0