|
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
04-11-2018, 01:18 AM
|
|||
|
|||
extract data from sheet using a between date and match criteria to total profit
I have a large spreadsheet cost and sales of materials I want to use the delivered date column and the company column to calculate profit for the 2 companies on a monthly basis
so between delivered dates 01/01/18 and 31/01/18 company sales or ltd extract data onto new sheet including profit column Thanks Trev Last edited by tj61; 04-11-2018 at 03:39 AM. Reason: added file 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Help Needed With Index/Match To Compare And Pull Data From One Sheet To Another
|
robertjohn81 | Excel | 1 | 01-19-2017 11:20 AM |
|
Create a unique list of values that match a criteria, sorted in order of another criteria
|
BradRichardson | Excel | 2 | 01-03-2017 12:25 AM |
| Copy data from one sheet to another based on a certain criteria | shina67 | Excel Programming | 2 | 12-28-2016 07:32 AM |
| Want to return a value from my pricing table into my raw data sheet given criteria in the data sheet | mcronin | Excel | 1 | 05-09-2016 09:43 AM |
| extract specific pivot table data to a new sheet | theexpat | Excel Programming | 0 | 02-18-2016 10:08 AM |
Windows 8 
Office 2007
Threaded Mode