=H2 + (L2/100) + (M2/1000) + (N2/100000) + (O2/1000000) + (P2/10000000) + (ROW()/1000000000)
Also instead =Large($D2:$G2,1) so on 2, 3. Put in =LARGE($D2:$G2,COLUMN(A1)) Copy across and down.
Here other way of tied break sample file.
Info are in the file.
Cheers![]()
Bookmarks