I am trying to find a formula to find the mode of the highlighted cells. The value inside cell D13 will determine the number of highlighted cells. If it is 3, 3 rows will be highlighted starting from cell H3. For example, if the highlighted cell contains 3 values B, B, and A. B will be returned to cell C13 as the mode value. I have attached a screenshot of my Excel, anyone can help me?
"I want to return the most occurrence alphabet."
You could use:
=LET(r,TAKE(H3:H10,D13),@SORTBY(r,COUNTIF(r,r),-1))