Results 1 to 12 of 12

Help with Index function to find range of cells

Threaded View

  1. #1
    Registered User
    Join Date
    02-23-2016
    Location
    California
    MS-Off Ver
    Excel 2016
    Posts
    8

    Help with Index function to find range of cells

    Hi,

    Want to extract data from a table based on certain criteria to create data for a scatter gram chart
    Extracted data will be in two columns of data & multiple rows; not just a single cell. I am looking for a way to put extracted data into a range of cells not just a single cell.

    See attached Excel file with the data, would like formula to place result in yellow highlighted area.

    Goal:
    Look for the desired title (NSS) in column E. For each occurrence of NSS automatically populate columns A and B with however many occurrences of desired title with corresponding yrs. of exp. and salary are found in Columns F and G. I've manually entered in data into column A and column B (yellow highlighted area) to show desired result.

    I think there's an easy solution here. I've tried a Vlookup & Index/Match formula but no luck & looked online & on Youtube for a solution. I think an array should work, just not sure how to set up formula. Any help would be greatly appreciated. Thanks!
    Attached Files Attached Files
    Last edited by Bretyuin; 02-24-2016 at 04:41 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 3
    Last Post: 01-22-2015, 06:21 PM
  2. Find value in range with two criterias, INDEX MATCH MAX
    By gnoke in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-24-2014, 07:48 AM
  3. [SOLVED] Correct syntax for function to find average based on background color of cells in range
    By moosetales in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 05-21-2014, 12:24 AM
  4. Find index of range/row in for each loop
    By vizzkid in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-26-2013, 08:10 AM
  5. Replies: 3
    Last Post: 09-17-2010, 11:07 AM
  6. Find last row in range using INDEX
    By skysurfer in forum Excel General
    Replies: 3
    Last Post: 09-03-2010, 02:23 PM
  7. Find Column Number and then use Index Function
    By modytrane in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 06-03-2008, 12:59 PM

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