|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
||||
|
||||
Hi and welcome
please post a sample sheet with some data and expected results. Thx
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
|||
|
|||
Something like this?
|
#4
|
|||
|
|||
yes that seems to work fine just need to understand how it works to replicate it
Thanks trev |
#5
|
||||
|
||||
See attached , Sheet2, basic pivot table, choose your month in B1.
|
#6
|
|||
|
|||
Thanks P45cal need to read up on Pivot Tables then
Trev |
|
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 |