Google search - how to create a dynamic list without blank in excel
The first result in the google search has been referenced for creating a dynamic list as attached in a sample worksheet(not a drop down though). Only problem is I need it to list the 7 names category wise like A B and C. My desired result is highlighted in yellow in column F. I want this to flow as a formula in column E.
heres an array formula for ya. So whenever you put this formula in make sure to use
ctrl +shift+enter
=IFERROR(INDEX($A$2:$B$14,SMALL(IF($A$2:$A$14="A",ROW($A$2:$A$14)-1),ROW(1:1)),2),"")
Just change the A to B or C. Also for the first line of B and C make sure that the bolded Row(1:1) is still 1:1.
Use a pivot table instead of formulas.
Click the * to say thanks.
Use this in G2, with similar formulae further down:
=IFERROR(INDEX(B:B,AGGREGATE(15,6,ROW($B$1:$B$50)/($A$1:$A$50=$G$1),ROWS(G$2:G2))),"")
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
This works fantastic. Thank you.Originally Posted by Glenn Kennedy
Thank you dosydos and PaulM100 for your suggestions too.
You're welcome.
If that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.
It'd also be appreciated if you were to click the Add Reputation button at the foot of any of the posts of all members who helped you reach a solution.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Jairam Jana 
Register To Reply
Bookmarks