Build formulas and macros in an Excel document

  • Posted:
  • Proposals: 12
  • Remote
  • #568324
  • Completed
James M.Agne S.Kenneth P.Kunj S.Mark M. + 7 others have already sent a proposal.
  • 0


Experience Level: Intermediate
Industry: Technology
Description of excel work: I am copying data from one source to an Excel Spreadsheet and I need to find specific information in the data and then have it averaged and copied to another sheet withing the same workbook.
CA - los angeles NY - queens (1) 2006 bmw 325 (Car)
(Los Angeles - Long Beach - Anaheim) (New York - Northern New Jersey - Long Island) $850 cod (Cash/Certified)
map map 2794 mi ($0.30/mi)
route map Order ID: 76554

In the above pasted data, I am looking for the cell that contains [ $850 cod (Cash/Certified) ] and the cell that contains [ 2794 mi ($0.30/mi) ]. I need the $850 amount only to be placed in a column and the 2794 amount only to be placed in another column. There will likely be 11 occurrences of each per paste. So I need to wind up with a column of, up to, 11 dollar amounts and another column of 11 mileage distances. After the columns are populated, I need to average each column and then divide the result of the dollar amount by the average of the distance to end up with an overall average of price per mile. Once the price per mile is calculated, I need to have it automatically copied to a designated next cell on another sheet within the same workbook.
Extra notes:

New Proposal

Create an account now and send a proposal now to get this project.

Sign up

Clarification Board Ask a Question

    There are no clarification messages.