Bug in Remove duplicates after sorting the data in ascending order and using Table.Buffer

[Anonymous]

Hi 

I am having a excel sheet with 3 columns : Supplier Name, Status and Points.

There are multiple records for the same supplier

We need to remove the duplicate suppliers by keeping the lowest value of points among the multiple records

I am facing issue in removing duplicates after sorting the data based on Points column using Table.Buffer

Expected output is to remove duplicate for same supplier and keep the record with the lowest value of points

Regards

Arun

[v-yingjl]

Hi @Anonymous ,

What's the error message that you have faced? As far as my test, before sorting and remove duplicated values using Table.Buffer(), it works fine.

Best Regards,
Community Support Team _ Yingjie Li