gordonhtfu
New Member
- Joined
- Jan 9, 2014
- Messages
- 9
Here is a sample (simplified) scenario that I am trying to resolve.
Given...
<COLGROUP><COL style="WIDTH: 54pt" span=5 width=72><TBODY>
</TBODY>
Trying to make it into this by removing all the duplicates:
<COLGROUP><COL style="WIDTH: 54pt" span=5 width=72><TBODY>
</TBODY>
Is there any method using formula? I am preferring formula (over macro or advanced filter) because it would dynamically update the result if the value in given table changes.
Given...
Tom | Peter | Sam | Susan | |
Combo1 | 1 | 2 | 1 | 3 |
Combo2 | A | A | B | A |
Combo3 | ! | @ | # | $ |
Combo4 | a | b | b | c |
<COLGROUP><COL style="WIDTH: 54pt" span=5 width=72><TBODY>
</TBODY>
Trying to make it into this by removing all the duplicates:
Combo1 | 1 | 2 | 3 | |
Combo2 | A | B | ||
Combo3 | ! | @ | # | $ |
Combo4 | a | b | c |
<COLGROUP><COL style="WIDTH: 54pt" span=5 width=72><TBODY>
</TBODY>
Is there any method using formula? I am preferring formula (over macro or advanced filter) because it would dynamically update the result if the value in given table changes.