Build formulas and macros in an Excel document
- or -
Post a project like this3495
$$
- Posted:
- Proposals: 11
- Remote
- #568324
- Completed
Very experienced Excel user (including VBA), data analyst, and report writer. Currently working in a full time position but available on evenings and weekends.
Llanelli
819746898636619398984114612281422351470483089553231739889743733
Description
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.
Example:
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:
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.
Example:
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:
Deron B.
100% (4)Projects Completed
3
Freelancers worked with
3
Projects awarded
78%
Last project
10 Dec 2014
United States
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies