I have a spreadsheet that I would like to easily update.

I would like to have a 1 enter in each cell of column E, IF Column H equals F or 3F AND the cell in column D does not match the cell above it.

I have attached a spreadsheet. A formula or macro would be SO appreciated!!!

Thank you so much in advance!

-Mary


Example1.xlsx