I have a table with 2 columns, NAME and ID.
I want to Type a name (In D4) and in column E, starting in E4 it will list the UNIQUE IDs going down.
Thanks.
I have a table with 2 columns, NAME and ID.
I want to Type a name (In D4) and in column E, starting in E4 it will list the UNIQUE IDs going down.
Thanks.
Last edited by aetedford; 09-26-2019 at 09:30 AM.
sample data
Hi there!
I've maneged to do it like this:
Please Login or Register to view this content.
.. and don't forget to have fun!
Bogdan.
mark SOLVED and Add Reputation if my answer pleases you
...or by formula:
=IFERROR(INDEX(B:B,AGGREGATE(15,6,ROW($B$2:$B$50)/(($A$2:$A$50=$E$4)*(COUNTIF($H$3:H3,$B$2:$B$50)=0)),ROWS(H$4:H4))),"")
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks