range N69:P93 contains data source:

- col N has minutes (could contain duplicate numbers)

- col O contains YES or 0

- col P has a formula - basically to check for a duplicate in N - if so the number is assigned a digiti e.g. if there are 2 x 45 minutes col P returns a 451 in first instance, then 452 in the next.

otherwise if conditions not met in P... result is just 0

i am then trying to sort column P dynamically by formula highest to lowest using this formula: IFERROR(SORT(UNIQUE(FILTER(P69:P93,P69:P93>=1)),,-1),"")

it seems to convert itself to an array.

it will work sometimes, but we have been noticing that if there is only 1 entry in the minute column... the highest to lowest top 5 all result with the same info.

it should only show the one result and rest be blank.

i cant get my plugin working sorry, and i can't share the workbook. so hoping you may be able to help.