• 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.

Array formulas to extract data

G

GFC

Member
In my Excel I have a list of people (one per row) that can chose from a list of 10 products (put in columns). At the crossing I have how many of this particular item they would like to have.

What I wanted to have, was an array formula which would give me on another sheet for a given person, a column with ONLY the list of item taken and in the next column the quantity ordered.


Is this possible?

Solved the problem differently with vlookups and hlookups, but still looking for an elegant array formula…
 
Sumproduct could work for this or maybe even index match. Going to need more info though. Hopefully you can upload an example.
 
You must log in or register to reply here.
Back
Top