Is there a way, in Excel, to extract certain items from one list and display them in order in a different list?
For example, suppose you have a spreadsheet in which column B contains a list of names and column C contains some designation for each name — in this case, a letter between A & E as shown here:
Is there a way for Excel to automatically populate a list which includes each name from column B for which the corresponding column C letter matches a letter entered manually in the box at F2? In other words, suppose the letter "A" is manually entered in cell F2 as shown in the next screenshot. What formula will result in the list (column F) of the names from column B with a corresponding "A" in column C?
And then in another example, if the manually-entered letter is "B", the resulting column F list should change as follows:
So the goal is not only to display the names matching the entered criteria, but display them in a list populated from top to bottom (with no blank rows) and in the same order as those names appear in the original (column B) list. The latter is illustrated in the next screenshot where changing the letter for Grace (yellow cell C15) to "B" causes her name to be inserted in its proper position (between Ashley & Sarah) in the results list (column F).
The desired functionality is identical to applying a filter to column C for the manually-entered letter (next screenshot below) to obtain the list of matching names as the new list (final screenshot below).
”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.
-Mike Kapnisakis, Warner Bros
With your subscription - you'll gain access to our exclusive IT community of thousands of IT pros. You'll also be able to connect with highly specified Experts to get personalized solutions to your troubleshooting & research questions. It’s like crowd-sourced consulting.
We can't always guarantee that the perfect solution to your specific problem will be waiting for you. If you ask your own question - our Certified Experts will team up with you to help you get the answers you need.
Our certified Experts are CTOs, CISOs, and Technical Architects who answer questions, write articles, and produce videos on Experts Exchange. 99% of them have full time tech jobs - they volunteer their time to help other people in the technology industry learn and succeed.
We can't guarantee quick solutions - Experts Exchange isn't a help desk. We're a community of IT professionals committed to sharing knowledge. Our experts volunteer their time to help other people in the technology industry learn and succeed.