I need to sort, tally, and extract data from one spreadsheet to another. - Upwork

1) I need a record count for column C (Loan Off NMLS ID)

Example: If you look at 539697, there are 4 records. I need this for each Loan Off NMLS ID on the spreadsheet

2) I need to breakdown by loan type (Column G)

Example: 539697 = 50% Conventional and 50% FHA

3) Volume for each Loan Type

Using our Example: FHA = $385,377 Conventional = $214,150

4) Breakdown by transaction type Column A

I've attached the master list - Loan Officer Production 7-11-16 to 1-19-17 is where the information is coming from. The information needs to go to the Loan Officer Data Consolidation Sheet (attached)

NOTE: ANY RECORDS WITH BLANK FIELDS FOR COLUMN C IN THE MASTER LIST DO NOT NEED TO BE INCLUDED.

Budget: $200
Posted On: March 09, 2017 16:01 UTC
Category: Admin Support > Data Entry
Skills: Data Analytics, Data Visualization, Microsoft Excel, Microsoft PowerPoint, Microsoft Word
Country: United States
click to apply

Apply Now: All jobs | upwork.com http://bit.ly/2n3JTp5