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.
Hi, I have 8 years experience in programming. I have sent personal message to you with the detailed solution.
Bu iş için 26 freelancer ortalamada $36 teklif veriyor
I have done many custom Excel projects and have excellent ratings.
Hi there, Its me pleasure to finish this task for you. If interested pls reply asap..... regards
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.
With more than 10 years experience in Excel and VBA programming, I can do it immediately.
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
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
I have the necessary skills to do this job - more than 20 years of experience in MSOffice