nickirvine
04-13-2011, 05:45 AM
Hi all,
I hope someone can help me with this.
I have one excel workbook that has one collumn with ID numbers and one collum with associated offices.
What I want to do is to be able to select an office (enter it into a cell) and it will display all the associated ID numbers in one cell. In this format: "12, 34, 56, 78," etc
This will enable me to copy this field and then use it elsewhere.
I have an excel forumula which will list all the details in a table but now i need to adapt it to put all the ID numbers in one cell.
The forumula I use to create this is:
=INDEX(codes!$B$2:$B$4193, SMALL(IF($D$2=codes!$A$2:codes!$A$4196, ROW(codes!$A$2:codes!$A$4196)-MIN(ROW(codes!$A$2:codes!$A$4196))+1, ""), ROW(C1)))
Can anyone help me with this? I'm thinking i may need to scrap the above formula and do it another way?
All help appreciated!
Thanks,
Nick
I hope someone can help me with this.
I have one excel workbook that has one collumn with ID numbers and one collum with associated offices.
What I want to do is to be able to select an office (enter it into a cell) and it will display all the associated ID numbers in one cell. In this format: "12, 34, 56, 78," etc
This will enable me to copy this field and then use it elsewhere.
I have an excel forumula which will list all the details in a table but now i need to adapt it to put all the ID numbers in one cell.
The forumula I use to create this is:
=INDEX(codes!$B$2:$B$4193, SMALL(IF($D$2=codes!$A$2:codes!$A$4196, ROW(codes!$A$2:codes!$A$4196)-MIN(ROW(codes!$A$2:codes!$A$4196))+1, ""), ROW(C1)))
Can anyone help me with this? I'm thinking i may need to scrap the above formula and do it another way?
All help appreciated!
Thanks,
Nick