+ Reply to Thread
Results 1 to 2 of 2

macro to search entire work book and do Index match with 2 criteria

  1. #1
    Forum Contributor
    Join Date
    04-28-2013
    Location
    Miami, United States
    MS-Off Ver
    Excel 2007
    Posts
    240

    macro to search entire work book and do Index match with 2 criteria

    I have a large workbook with employee attendance and I would like to pull the attendance data for each employee by date.

    Is there a macro that can do this?

  2. #2
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    2013 / 2016 / 365
    Posts
    7,067

    Re: macro to search entire work book and do Index match with 2 criteria

    Without seeing the workbook, I can only offer suggestions.

    If the data are organized in a "normalized" fashion, then a pivot table will work.

    The SUMIFS (or SUMPRODUCT) can get sums based on multiple criteria.

    If you are trying to extract non-numeric data then using a composite ([Employee ID] & ":" & [Date]) along with INDEX / MATCH might help.

    The chances are good that you do not need a macro to do this. Regular formulas should handle it.
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

+ 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. Replies: 17
    Last Post: 10-21-2016, 02:10 PM
  2. Replies: 4
    Last Post: 04-27-2015, 02:42 PM
  3. How to add multiple subs / criteria to one work book macro vba
    By no1freeman in forum Excel Programming / VBA / Macros
    Replies: 25
    Last Post: 03-07-2015, 03:51 AM
  4. [SOLVED] Array index with 3 way match criteria of 2 rows and 1 column cant get to work!
    By volchik696 in forum Excel Formulas & Functions
    Replies: 20
    Last Post: 01-20-2014, 06:18 AM
  5. Replies: 2
    Last Post: 06-29-2013, 11:58 PM
  6. [SOLVED] Index match formula to search for two criteria (date & name)
    By davechamp1983 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-17-2012, 10:00 PM
  7. Building upon an INDEX and MATCH search with expanded criteria.
    By parky58 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-20-2012, 03:17 AM

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