capture the highest of each group

  1. multirow formular then filter

  2. sort by desc then unique tool with group