trademark2k6
New Member
- Joined
- Oct 19, 2017
- Messages
- 2
Hi All,
New to the forum but have had loads of help from reading all the articles in the past. I have a tricky task which I am trying to achieve with excel and not sure if it is possible.
I have a table that is laid out like below (with a couple rows completed).
I want to be able to generate a list like this:
List of authors with their affiliations: Mark T [1][2][3], Smith P [4], Cruise K [2]
Separately, I want a list of all the selected affiliations and the assigned number:
As you can see Author 1 (Mark T) has 1,2,3 marked against his name.
Smith P also has UoB listed like Mark T, but because t is a different group his name is listed as Smith P [4]
If any author selects the same affiliation, they share the same number. E.g. Cruise K is also in Group 1 of UoB, which is the same as Mark T. Therefore both will have the number [2] next to their names.
Each affiliation should be numbered according to first. So because Mark T has selected BRC as Yes, BRC is numbered as [1] and if anyone else selects the same, they will also have [1] next to their name.
Complicated, but hoping someone has some tricks to make this work!
Thanks
<tbody>
</tbody>
New to the forum but have had loads of help from reading all the articles in the past. I have a tricky task which I am trying to achieve with excel and not sure if it is possible.
I have a table that is laid out like below (with a couple rows completed).
I want to be able to generate a list like this:
List of authors with their affiliations: Mark T [1][2][3], Smith P [4], Cruise K [2]
Separately, I want a list of all the selected affiliations and the assigned number:
- [1] BRC
- [2] Group 1
- [3] UHB
- [4] Group 2
As you can see Author 1 (Mark T) has 1,2,3 marked against his name.
Smith P also has UoB listed like Mark T, but because t is a different group his name is listed as Smith P [4]
If any author selects the same affiliation, they share the same number. E.g. Cruise K is also in Group 1 of UoB, which is the same as Mark T. Therefore both will have the number [2] next to their names.
Each affiliation should be numbered according to first. So because Mark T has selected BRC as Yes, BRC is numbered as [1] and if anyone else selects the same, they will also have [1] next to their name.
Complicated, but hoping someone has some tricks to make this work!
Thanks
| Author Information | Name (eg. Smith J) | Affiliation: BRC (Y/N) | Affiliation: UoB (Group 1,2,3) | Affiliation: UHB (Y/N) |
| Author 1 | Mark T | Yes | Group 1 | Yes |
| Author 2 | Smith P | No | Group 2 | No |
| Author 3 | Cruise K | No | Group 1 | No |
| Author 4 | ||||
| Author 5 |
<tbody>
</tbody>
