Extract data from column B for month (colA), matching category (C) and search words (D)
Hiya! We have a long list of data with only four columns:
A - date
B - amount
C - category
D - descriptionand I would like to find a way to easily set aside some data from this data series, per month. For example, I would like to know for February (date) how much (amount) we spent on machine repairs (description) in our packaging area (category). And so on, and so forth.
I figured using an IFS-function would be best, but I haven't been able to figure out how to factor in the whole of February without manually putting in the range with February dates. I would rather it find the February dates for itself.
Last edited by QuieT; 01-04-2021 at 04:38 PM.
Re: Extract data from column B for month (colA), matching category (C) and search words (D
Post a small Excel sheet (not a picture) showing realistic & representative sample data WITHOUT confidential information (10-20 rows, not thousands...) and some manually calculated results. Just before posting, scroll down to GO ADVANCED, click, and then scroll down to MANAGE ATTACHMENTS and click again. Now follow the instructions at the top of that screen.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
By Ijustneedsomething in forum Excel Programming / VBA / Macros
Last Post: 03-28-2017, 09:23 AM
By kolokoy in forum Excel Formulas & Functions
Last Post: 05-13-2016, 11:11 AM
By MicroTees in forum Excel Programming / VBA / Macros
Last Post: 11-19-2015, 11:28 PM
By roothog in forum Excel Formulas & Functions
Last Post: 10-03-2015, 07:08 AM
By apple_tree in forum Excel General
Last Post: 10-12-2014, 08:53 AM
By Jimbo42 in forum Excel Programming / VBA / Macros
Last Post: 09-07-2012, 05:23 PM
By cquest in forum Excel Formulas & Functions
Last Post: 10-25-2011, 10:48 AM
Tags for this Thread
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1