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
Bookmarks