excel keep only first occurrence of id code example
Example: excel keep only first occurrence of id
1. Go to the data tab and click on 'Advanced' under 'Sort & Filter';
2. In the pop up, put the list range as the criteria column (header included) and
3. Check the 'Unique records only' checkbox.
4. Click OK and that should be it.