• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Return Multiple data from a data set

B

badger

New Member
1749045039525.png
Above is a small extract from a large data set, based on the department name selection in A13 I would like to extract all relevant data in the grey area and put into the green section - see in this example I would expect to see 3 lines of data relating to IT. A formula based approved is what I am after.

Thanks in advance.
 
how about
In cell A15 put
=filter(A3:I9,A3:A9=A13)
assuming your version of excel supports FILTER()

Post what version of excel you have

and the range will need to be changed to support, whatever data range you have

Note: Images are difficult to see , and also requires that I input all the data myself, which means I may make an error, which is very time consuming, and from my point of view less likely to get a response, if a complicated spreadsheet.

A sample sheet would help here, and possibly will enable a quicker and more accurate solution for you.

The forum does allow for spreadsheets to be uploaded direct to the forum -
 
You must log in or register to reply here.
Back
Top