Forum Discussion
Advocate IHow to view distinct values in a column?
Hello,
Do you need just to see the distinct values or you want a code to list them somehow or to make a count of duplicates if any?
If you just want to see distinct values of a column you can click on the down arrow of a column and it will show you, just like in Excel, a list of all distinct values. Another "viewing" option would be to do a Group by in Power Query by your column that will give you a list of all distinct values.
Otherwise, you have to be more specific about your needs.
Regards,
ElenaN
Resolver VHello,
Do you need just to see the distinct values or you want a code to list them somehow or to make a count of duplicates if any?
If you just want to see distinct values of a column you can click on the down arrow of a column and it will show you, just like in Excel, a list of all distinct values. Another "viewing" option would be to do a Group by in Power Query by your column that will give you a list of all distinct values.
Otherwise, you have to be more specific about your needs.
Regards,
ElenaN
RayLIt worked. Thank you Elena for helping out a newbie :)