Sum max min with duplicates

you Have a table consisting of two columns: a column of duplicate text values and column numbers. We will create a table consisting only of lines with unique text values. By the numeric column will produce a calculation of the average.

Find the maximum/ minimum among duplicate values.

Find the maximum/ minimum only among the distinct values.

you Have a table consisting of two columns: a column of duplicate text values and column numbers. We will create a table containing only rows with unique text values. By the numeric column will produce the summation of the corresponding values.

the Range of summation contains duplicate values. Will produce only those numbers which have duplicates.

given a table with two columns: a text column with duplicates and a numeric column. Will sum only those numbers that match non-recurring text.

the Range of summation contains duplicate values. Fold Chisel only those that do not have duplicates.

Let the range of summation contains duplicate values. Perform the addition of NUMBERS without dupes.