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!
|