kramasundar
New Member
- Joined
- Aug 2, 2010
- Messages
- 18
Hi,
I have an excel file with two sheets S1, S2 (please see below for sample content). All sheets are in one excel file.
For each cell in sheet S1, I have to check whether there is/are an/multiple entry/entries in sheet S2. If there are entries, then I would like to count the unique types and its number of occurrences.
In the example below, in the result sheet, id 123 has 4 rows with the following data
- 2 times Type A
- 2 times Type B
- 1 time Type C
- 1 time Type D
Could you guys please help me?
Thanks and best regards,
R
S1's content is as follows:
<tbody>
</tbody>
S2's content is as follows:
<tbody>
</tbody>
I expect a result like below in sheet 3 for e.g.:
<tbody>
</tbody>
I have an excel file with two sheets S1, S2 (please see below for sample content). All sheets are in one excel file.
For each cell in sheet S1, I have to check whether there is/are an/multiple entry/entries in sheet S2. If there are entries, then I would like to count the unique types and its number of occurrences.
In the example below, in the result sheet, id 123 has 4 rows with the following data
- 2 times Type A
- 2 times Type B
- 1 time Type C
- 1 time Type D
Could you guys please help me?
Thanks and best regards,
R
S1's content is as follows:
123 |
124 |
125 |
126 |
127 |
128 |
129 |
<tbody>
</tbody>
S2's content is as follows:
123 | text | Type A |
123 | text | Type B |
123 | text | Type A |
123 | text | Type B |
123 | text | Type C |
123 | text | Type D |
124 | text | Type D |
125 | text | Type D |
125 | text | Type A |
<tbody>
</tbody>
I expect a result like below in sheet 3 for e.g.:
123 | Type A | 2 |
123 | Type B | 2 |
123 | Type C | 1 |
123 | Type D | 1 |
124 | Type D | 1 |
125 | Type D | 1 |
125 | Type A | 1 |
<tbody>
</tbody>