the google sheet is capable of comparing data and selecting the lowest value. We have check box in every other coulmn. For example, only one check box should be checked in the row # 8 and data from coulmn (H, L, L, N, P, R, T, V, X and Z) get copied to row 8 coulmn G and the coilor of the cell changes to Green, when the check box is checked next to the coulmn.
Also only one check box should be checked in the row # 7 and data from coulmn (H, L, L, N, P, R, T, V, X and Z) get copied to row 8 coulmn F and the color of the cell changes to Yellow, when the check box is checked next to the coulmn.
When the check box is unchecked, it should delete the data in row 8, coulm F and G accordingly.