libreoffice

I would like to know how I can perform the following filter: ===> I.e. how to remove the duplicates in the "action" c ... hest priority record (in the case, '1 'is the person with the highest priority and' 8 ' the person with the lowest priority).

I'm creating a macro in LibreOffice Calc and I need a way to select some non-consecutive cell ranges, and capture what those ... a" replace " in the selected cells, but it only works in a single interval. Thank any hint. Https://pastebin.com/4BtGjuVc