Filter data with conditions

Thank you so much.
However I made a mistake in my explanation, regarding MAX H3:H500, please see attached

Please see a7
I need MAX of G3:G500 as driving condition, which is 6
So I have Result together a7-6
Then (here was my mistake) I need MAX of H3:H500 for Result, which is 4

So not MAX of H3:H500 for a7, but for a7-6

So my L column is mistake

The way I was explaining before , MIX/alter the records