JYool
New member
I have an interesting challenge... what i am trying to accomplish, is a comma separated list of all the project names that an employee has been working on... for instance if b13:b33 has the following values:
project1
project1
project7
project9
project1
project7
project1
project1
etc.
i want to return to one cell the following: project1/project7/project9
I did this for the work category using a hidden reference column, returning a numeric value that is stored in a seperate table to find the minimum value, and return the corresoponding text... but the resulting formula is a bunch of if/else results; i capped it at three, so they are either one type, one/two type or multiple type... but i do need a complete list of projects i think, and i don't want a collection of job1, job2, job3...
i have made another index cell that uses the following formula =INDEX($C$14:$C$33,MATCH(0,COUNTIF($AM$14:AM14,$C$14:$C$33),0)) to create a list that looks like this
project1
project7
project9
0
#N/A
#N/A
i would again need to nest a bunch of if(isna()) forumlas to get what i need, and that doesn't sound ideal.
so if anyone has an idea how to deal with this at either stage (the reference column, or the original list) that would be great
I am trying to expand my knowledge of VB, but am learning from the ground up, as i don't have time for more courses. Can someone point me in the right direction? at this point, I'm pretty good at reverse engineering other people's code to get it to fit my needs, but cannot do anything from scratch.
thanks in advance!
project1
project1
project7
project9
project1
project7
project1
project1
etc.
i want to return to one cell the following: project1/project7/project9
I did this for the work category using a hidden reference column, returning a numeric value that is stored in a seperate table to find the minimum value, and return the corresoponding text... but the resulting formula is a bunch of if/else results; i capped it at three, so they are either one type, one/two type or multiple type... but i do need a complete list of projects i think, and i don't want a collection of job1, job2, job3...
i have made another index cell that uses the following formula =INDEX($C$14:$C$33,MATCH(0,COUNTIF($AM$14:AM14,$C$14:$C$33),0)) to create a list that looks like this
project1
project7
project9
0
#N/A
#N/A
i would again need to nest a bunch of if(isna()) forumlas to get what i need, and that doesn't sound ideal.
so if anyone has an idea how to deal with this at either stage (the reference column, or the original list) that would be great
I am trying to expand my knowledge of VB, but am learning from the ground up, as i don't have time for more courses. Can someone point me in the right direction? at this point, I'm pretty good at reverse engineering other people's code to get it to fit my needs, but cannot do anything from scratch.
thanks in advance!