1
Only with macro, programming VBA. In Libreoffice Calc, without using macro, it is possible to make a filter for a line, and not generate all lines. It would be generated one line at a time.
The table boils down to cells A1:C9.
The other cells are formulae, except cell C13, which must be changed.
Now we go to the formulas. The character "=" was purposely removed for the display of the formula.
In cell B16, the lowest "Priority" of the chosen "Action" is calculated.
In cell A19, the "Name" for "Priority" and "Action" are calculated".
Line 19 would be the filter itself.
You use Excel or libreoffice?
– danieltakeshi
In the case of example, I did in Excel, but I would like to understand a solution for both, if possible.
– michelvmelo
There are several ways to compare or find strings. A list with some Find methods can be found in the link response. After each data located is compared... A quick way is to use Autofilter in the action column for an action and then check the higher value of the visible cells with a Worksheetfunction.Min(). Because the native method of Excel VBA
.RemoveDuplicate
does not have this logical function to check the priority.– danieltakeshi
Behold this answer also
– danieltakeshi