Filling Empty cell value based on if else condition and delete row more than 2 cells empty

Here find the excel file

My requirement

1) 4 values contains in each row based on the values from those cells the max value will display.

2) if more than 2 cells have empty,NR or NA text means the entire row has to delete.

3) if 2 or more that means 3 cells having values the empty cell,NR or NA cell will place value with the condition of macro that is 75% of other values which is maximum among them.

I did my level best for doing this coding please help me out in urgent

Please Login or Register  to view this content.

Any help plz friends