Pick the first duplicat value ($R$4:$R) based on each of them must be have high number on column ($T-CodePudding

Home > Mobile > Pick the first duplicat value ($R$4:$R) based on each of them must be have high number on column ($T

Pick the first duplicat value ($R$4:$R) based on each of them must be have high number on column ($T

Time：10-26

I want to make a duplicat value which are refferance from ($R$4:$R) column. Based on each have a highest number of them on column of ($T$4:$T) as a criteria and want to do this all with arrayformula.

I've tried my formula on "T E S T" column on (AE3) but it doesn't gave me the rights output as I want as I imagine it.

See the pic I atteched here below :

And my gsheet's doc please feel free to edit because I hope that you will. It makes me happy ^_^ :

Page link：https//www.codepudding.com/Mobile/588735.html

Prev:Google Sheet - It's possible to array sum function in the following condition?

Next:Google Sheets - transpose irregular column data in groups into rows

Tags：

google-sheetsgoogle-sheets-formulaformulaarray-formulas

Links：
CodePudding