Hi,

I would like to create a macro that would clear contents of a cell if its value is the same as the same cell in the previous row.

For example I have a spreadsheet (query output) that repeats the data across columns A-E because column F has a different value. I would like to compare the ID's and if the same, clear the contents of all cells in the repeated row, except the contents of cells in F column. SampleOf_Clear_Contents_IfSame_As_Previous.xlsx

Thanks in advance for your expertise.