Dear all,
I have been doing the following problem:
I have a table
<colgroup><col span="5"></colgroup><tbody>
</tbody>
So in the main field whenever the training for a person matches one the three trainings names in the header row, it returns one.
I want to have only one row for a person, but so that all the trainings he/she did will be dispayed in the same row with 1 (and not having 3 rows with mark), like this:
Name Welcome Day Night
Mark 1 1
Polyak 1 1
Avril 1 1
Can somebody help me with the formulas needed for such an operation in excel?
I was thinking of doing something like while the name is still mark, check matching the header columns with trainings row, and return one if they match.
I would be very thankful!
I have been doing the following problem:
I have a table
| Name | Training | welcome | day | night |
| mark | welcome | 1 | ||
| mark | two | |||
| mark | day | 1 | ||
| mark | some | |||
| Polyak | day | 1 | ||
| Polyak | night | 1 | ||
| Polyak | one | |||
| Polyak | two | |||
| avril | day | 1 | ||
| avril | night | 1 |
<colgroup><col span="5"></colgroup><tbody>
</tbody>
So in the main field whenever the training for a person matches one the three trainings names in the header row, it returns one.
I want to have only one row for a person, but so that all the trainings he/she did will be dispayed in the same row with 1 (and not having 3 rows with mark), like this:
Name Welcome Day Night
Mark 1 1
Polyak 1 1
Avril 1 1
Can somebody help me with the formulas needed for such an operation in excel?
I was thinking of doing something like while the name is still mark, check matching the header columns with trainings row, and return one if they match.
I would be very thankful!
