Results 1 to 4 of 4

INDEX MATCH every instance

Threaded View

  1. #1
    Registered User
    Join Date
    10-25-2017
    Location
    United States
    MS-Off Ver
    2019
    Posts
    77

    INDEX MATCH every instance

    I have a spreadsheet that spans across many columns in a uniform way. The information is in every 4th column and thought I could write a INDEX MATCH formula to produce a unique list for every time the criteria is met. I've tried to write the formula to grab every 4th instance, but the challenge is the match part looks at the first 'Color' instance so when the information changes to 'Pigment', those values are included within the list.

    I am searching for a formula to make a list from the values in row 3 if the value in row 2 = 'Color'.

    Thank you!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Index & Match - return the next instance or x number of instances
    By catmm in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-25-2022, 12:36 PM
  2. [SOLVED] Extracting First Instance from Index (Match) function
    By NMacs in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 02-10-2022, 03:21 PM
  3. Countif/Index/Match - need to count all instance
    By kinirobin in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 10-17-2019, 08:05 AM
  4. find nth instance using index match
    By melvinkoshy in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 04-03-2019, 12:50 PM
  5. Speed up Excel Index Match - First Instance
    By lesaiot29 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-28-2018, 11:55 AM
  6. [SOLVED] Index/ Match Last Instance
    By Burt_100 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 07-29-2015, 12:05 AM
  7. [SOLVED] Index / Match to find next instance of a value
    By boylers75 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-10-2012, 10:06 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