+ Reply to Thread
Results 1 to 2 of 2

Extract data from column B for month (colA), matching category (C) and search words (D)

  1. #1
    Registered User
    Join Date
    01-24-2020
    Location
    Just behind that tree
    MS-Off Ver
    2013
    Posts
    13

    Question 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 - description
    and 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.

    Any thoughts?
    Attached Files Attached Files
    Last edited by QuieT; 01-04-2021 at 04:38 PM.

  2. #2
    Forum Expert
    Join Date
    09-25-2015
    Location
    Milan Italy
    MS-Off Ver
    office 365
    Posts
    1,729

    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.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Removing Duplicates in ColA Keep Unique Data in Column AC
    By Ijustneedsomething in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-28-2017, 09:23 AM
  2. [SOLVED] How to extract non-matching data of two columns into another column
    By kolokoy in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-13-2016, 11:11 AM
  3. vba to replace old value by target value search almost key words matching
    By MicroTees in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-19-2015, 11:28 PM
  4. [SOLVED] extract data with multiple headers and dates in colA
    By roothog in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-03-2015, 07:08 AM
  5. Replies: 15
    Last Post: 10-12-2014, 08:53 AM
  6. [SOLVED] Search Cells for key words and add category code
    By Jimbo42 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-07-2012, 05:23 PM
  7. Matching Whole Words Only in a Lookup / Search Function
    By cquest in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 10-25-2011, 10:48 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1