I have a table of which this is an extract:
<colgroup><col><col><col><col span="2"></colgroup><tbody>
</tbody>
I want a list of the colour combinations used e.g.:
white black
brown yellow
blue yellow
and a list of the colour combinations for each design eg:
plain:
white black
brown yellow
paisley:
blue yellow
I need them listed in a column each. I know can use a data filter but it needs to be dynamic and not manual.
Does excel have a function for this already?
design | foreground | background | size | type |
plain | white | black | XL | T-shirt |
plain | white | black | M | T-shirt |
plain | brown | yellow | L | cap |
paisley | blue | yellow | L | cap |
paisley | blue | yellow | M | T-shirt |
<colgroup><col><col><col><col span="2"></colgroup><tbody>
</tbody>
I want a list of the colour combinations used e.g.:
white black
brown yellow
blue yellow
and a list of the colour combinations for each design eg:
plain:
white black
brown yellow
paisley:
blue yellow
I need them listed in a column each. I know can use a data filter but it needs to be dynamic and not manual.
Does excel have a function for this already?