Shortlist non-blank cells in a column based on duplicate entries in another column
hi,
Here's a summary of the problem I am facing. I think it's easiest to show the source excel and desired outcome I'd like to acheive.
I have attached the excel file with both Source and Desired Outcome sheets.
I have tried several INDEX/MATCH/ISBLANK combinations, but am at my wits end now
Looking forward to some help.
thnx
SB
On B20, enter this formula and fill across and down =IFERROR(INDEX(B$3:B$10,MATCH(1,INDEX(($A$3:$A$10=$A20)*(B$3:B$10<>""),0),0)),"")
This worked brilliantly. Thanks for sharing.Originally Posted by JieJenn
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Also, as a new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.
Dave
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks