Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-24-2016, 01:19 AM
bretyuin bretyuin is offline Help with Index Function to Select Range of Cells Windows 10 Help with Index Function to Select Range of Cells Office 2016
Novice
Help with Index Function to Select Range of Cells
 
Join Date: Feb 2016
Posts: 1
bretyuin is on a distinguished road
Default 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!
Attached Files
File Type: xlsx Question.xlsx (14.4 KB, 9 views)
Reply With Quote
  #2  
Old 02-24-2016, 05:11 AM
xor xor is offline Help with Index Function to Select Range of Cells Windows 10 Help with Index Function to Select Range of Cells Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,097
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default Help with Index Function to Select Range of Cells

Maybe like this.
Attached Files
File Type: xlsx bretyuin.xlsx (16.2 KB, 8 views)
Reply With Quote
Reply

Tags
index

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Help with Index Function to Select Range of Cells select a cluster of point from a range based on x and y values sandcharles Excel 5 02-19-2015 06:15 AM
Help with Index Function to Select Range of Cells 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

Other Forums: Access Forums

All times are GMT -7. The time now is 12:19 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft