Forum Discussion
make a list of objects having a text as value
Similar to PeterBartholomew1 solution, but without helper column and Ctrl+Shift+Enter is not required.
In G3 formula is
=IFERROR( INDEX(B:B, AGGREGATE(15,6, ROW($E$3:$E$51)/($E$3:$E$51=$J$2), ROW()-ROW($J$2)) ), "")and drag it to the right and after that G3:J3 down till empty cells appear.
Not sure what do you mean under objects and what are #valeur or #nom.
Above formula is for English version, if you open attached file formula in it will be in your locale if it's different.
Similar to PeterBartholomew1 solution, but without helper column and Ctrl+Shift+Enter is not required.
In G3 formula is
=IFERROR( INDEX(B:B, AGGREGATE(15,6, ROW($E$3:$E$51)/($E$3:$E$51=$J$2), ROW()-ROW($J$2)) ), "")and drag it to the right and after that G3:J3 down till empty cells appear.
Not sure what do you mean under objects and what are #valeur or #nom.
Above formula is for English version, if you open attached file formula in it will be in your locale if it's different.
thank you for answering
I am afraid it doesn't work on with my version, French 2010
Never mind
thank you
I will update sometimes
martineDo , you are welcome
Most probably it shall work on Excel 2010. Formula in the post for the English version, but open attached to the post file, it shall be the same in your (French) locale.