Hi ,
I need to have al incidents created by a user in my "Result" sheet.
I've tried to use the Index & Match function combined with aggregate. But this seems not to work for me.
See --> xelplus.com/return-multiple-match-values-in-excel/[/url]
This just an example my actual sheet contains more columns.
ps: I cannot use the filter function
Thanks in advance!
Hi,
put this in A2 and across:
=IFERROR(INDEX(Data!$B$1:$B$13,AGGREGATE(15,6,IF(Data!$C$1:$C$13=Result!A$1,ROW(Data!$C$1:$C$13)),ROWS(Data!$A$1:Data!A1))),"")
This works fine here:
=IFERROR(INDEX(Data!$B:$B,SMALL(IF(Data!$C:$C=A$1,ROW($A:$A)),ROWS($A$1:A1))),"")
AliGW on MS365 Insider (Windows) 64 bit
Piet Jan Bart Johnny INC0125 INC0126 INC0127 INC0128 INC0132 INC0131 INC0130 INC0129 INC0136 INC0133 INC0134 INC0135
Sheet: Result
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
If I am reading this correctly...
Belinda's formula is very complicated...
Ali's is an array formula (which should never be used on whole columns) and she forgot to mention it was an attay formula.
This is a normal formula (just enter):
=IFERROR(INDEX(Data!$B:$B,AGGREGATE(15,6,ROW(Data!$C$2:$C$20)/(Data!$C$2:$C$20=A$1),ROWS(A$2:A2))),"")
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.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Agreed and yes - I almost always forget now I have MS365!!! Oops ...Ali's is an array formula (which should never be used on whole columns) and she forgot to mention it was an attay (sic) formula.
BUT the OP has Excel 2019, so may not need to array enter ...
I think it's only non-array from 365.
I think mine is also an array......needs to be confirmed with CTRL + SHIFT + ENTER
Thank you Glenn!
This was the solution I was looking for!
You're welcome.
It would be very nice if you were to just click the Add Reputation button at the foot of any of the posts of members who helped you reach a solution.
Finally, if that takes care of your original question, please select "Thread Tools" from the menu link (just above the first post in the thread) and mark this thread as SOLVED.
There were two others (including myself) who offered help. Did we not deserve a 'thank you'? Plesae try to remember that EVERYONE here is giving generously of their free time and NOBODY is bing paid to help you. Common courtesy costs you nothing more than a few seconds of your time.Originally Posted by ToonV1
Thank you Glenn!
This was the solution I was looking for!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks