Hello there,
I know you can remove duplicates with the 'Remove Duplicates' tab, however is there a way to do it formula wise, including an if statement?
For instance, in the dataset below, I need the unique values for each fruit. So, for instance, the unique values for Oranges would be 1, 2 and 3.
Apples - 1, 2, 3, 4, 5
Pears - 1, 2
<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>
</tbody>
Is there a way to achieve this?
Many Thanks
I know you can remove duplicates with the 'Remove Duplicates' tab, however is there a way to do it formula wise, including an if statement?
For instance, in the dataset below, I need the unique values for each fruit. So, for instance, the unique values for Oranges would be 1, 2 and 3.
Apples - 1, 2, 3, 4, 5
Pears - 1, 2
<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody> </tbody> |
<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>
</tbody>
Is there a way to achieve this?
Many Thanks