Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page extract data from sheet using a between date and match criteria to total profit
Register FAQ Mark Forums Read

Reply
 
Thread Tools Display Modes
  #1  
Old 04-11-2018, 01:18 AM
tj61 tj61 is offline extract data from sheet using a between date and match criteria to total profit Windows 8 extract data from sheet using a between date and match criteria to total profit Office 2007
Novice
extract data from sheet using a between date and match criteria to total profit 		 
Join Date: Apr 2018
Location: norfolk uk
Posts: 3
tj61 is on a distinguished road
Default 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
Attached Files
File Type: xlsx TEST DATA.xlsx (18.6 KB, 10 views)
Last edited by tj61; 04-11-2018 at 03:39 AM. Reason: added file
Reply With Quote
  #2  
Old 04-11-2018, 03:12 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline extract data from sheet using a between date and match criteria to total profit Windows 7 64bit extract data from sheet using a between date and match criteria to total profit Office 2010 64bit
Expert
  
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,767
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default
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
Reply With Quote
  #3  
Old 04-11-2018, 07:12 AM
ArviLaanemets ArviLaanemets is offline extract data from sheet using a between date and match criteria to total profit Windows 8 extract data from sheet using a between date and match criteria to total profit Office 2016
Expert
  
Join Date: May 2017
Posts: 873
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
Default
Something like this?
Attached Files
File Type: xlsx TEST DATA.xlsx (61.1 KB, 11 views)
Reply With Quote
  #4  
Old 04-11-2018, 07:38 AM
tj61 tj61 is offline extract data from sheet using a between date and match criteria to total profit Windows 8 extract data from sheet using a between date and match criteria to total profit Office 2007
Novice
extract data from sheet using a between date and match criteria to total profit 		 
Join Date: Apr 2018
Location: norfolk uk
Posts: 3
tj61 is on a distinguished road
Default
yes that seems to work fine just need to understand how it works to replicate it

Thanks

trev
Reply With Quote
  #5  
Old 04-12-2018, 06:48 AM
p45cal's Avatar
p45cal p45cal is offline extract data from sheet using a between date and match criteria to total profit Windows 10 extract data from sheet using a between date and match criteria to total profit Office 2010 32bit
Expert
  
Join Date: Apr 2014
Posts: 866
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default
See attached , Sheet2, basic pivot table, choose your month in B1.
Attached Files
File Type: xlsx MSOfficeForums38749TEST DATA-1.xlsx (63.8 KB, 9 views)
Reply With Quote
  #6  
Old 04-13-2018, 12:08 AM
tj61 tj61 is offline extract data from sheet using a between date and match criteria to total profit Windows 8 extract data from sheet using a between date and match criteria to total profit Office 2007
Novice
extract data from sheet using a between date and match criteria to total profit 		 
Join Date: Apr 2018
Location: norfolk uk
Posts: 3
tj61 is on a distinguished road
Default
Thanks P45cal need to read up on Pivot Tables then

Trev
Reply With Quote
Reply

« Previous Thread | Next Thread »
Thread Tools
Display Modes
Linear Mode Linear Mode


Similar Threads
Thread Thread Starter Forum Replies Last Post
extract data from sheet using a between date and match criteria to total profit Help Needed With Index/Match To Compare And Pull Data From One Sheet To Another robertjohn81 Excel 1 01-19-2017 11:20 AM
extract data from sheet using a between date and match criteria to total profit 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

Other Forums: Access Forums

All times are GMT -7. The time now is 03:08 AM.

Contact Us - Privacy Statement - Top

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft