[Solved] Select range of cells with same value and find the middle cell [closed]

by


This returns the column name:
=INDIRECT(ADDRESS(1,CEILING((MATCH(MIN($BHS2:$BWT2),$BHS2:$BWT2) - MATCH(MIN($BHS2:$BWT2),$BHS2:$BWT2,0))/2 + MATCH(MIN($BHS2:$BWT2),$BHS2:$BWT2,0),1)))

(if you know that the smallest group is always the first group, then this could be simplified a little)

This returns the value
=min($BHS2:$BWT2)

Do you actually want to return both “4” and “PRT Product 322” in BWU2? i think it would be better to return “4” into BWU2 and “PRT Product 322” into BWV…or something like that…

1

solved Select range of cells with same value and find the middle cell [closed]