#1
|
|||
|
|||
Help with Index Function to Select 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 file with layout of info, want output from formula to go into yellow highlighted area. Goal: Look for the desired title (NSS) in column D. 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 Data Table. I've manually entered in data into column A and column B to just desired result. I think there's an easy solution here. I've tried an 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! |
#2
|
|||
|
|||
Help with Index Function to Select Range of Cells
Maybe like this.
|
Tags |
index |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
select a cluster of point from a range based on x and y values | sandcharles | Excel | 5 | 02-19-2015 06:15 AM |
Index Match function | jackzha | Excel | 5 | 12-03-2014 12:43 PM |
Copying text range of cells to different cells adds an extra line | jpb103 | Word VBA | 2 | 07-23-2014 12:22 PM |
Way to select a range using the mouse on a chart? | omahadivision | Excel Programming | 6 | 12-29-2012 09:21 AM |
Count range cells eliminating merge cells | danbenedek | Excel | 0 | 06-15-2010 12:40 AM |