Two (Relatively) Simply Excel functions needed
- Status Completed
- Budget $30 - $250 USD
- Total Bids 26
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.Get free quotes for a project like this
Looking to make some money?
- Set your budget and the timeframe
- Outline your proposal
- Get paid for your work
Hire Freelancers who also bid on this project
Looking for work?
Work on projects like this and make money from home!Sign Up Now
- The New York Times
- Wall Street Journal
- Times Online