Need a macro to clear contents of a cell if its value is the same as the previous cell

[Corina]

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.

[TMS]

If your objective is to clear those fields for printing purposes, it would be safer just to use Conditional Formatting to set the font and background colour to white, thus hiding the content.

Other than that, I think that deleting the content would be a mistake. Whilst it may look pretty, it will be useless in terms of analysing the data as you will no longer have the "linking" data fields.

And, more often than not, a sequence such as you have in column F would be a formula based on the content of, say, column A ... though it isn't in this case.

Regards, TMS

[Debraj Roy]

I agree with TMS..

its a good suggestion..

still here is a "Junky-Funky" code for the same..

Please Login or Register  to view this content.

[Corina]

Thank you for the suggestion. If it were merely for printing, I agree. This spreadsheet will be published for searching by users. If I don't clear some content, it makes searching through all of the duplicates too time consuming. I was thinking that if I could clear contents of D and E , or at least E which truly has the bulk of the text in the real spreadsheet, based on ID that would work.

[TMS]

One way then:

Please Login or Register  to view this content.

Regards, TMS

[JOHN H. DAVIS]

FWIW:

Please Login or Register  to view this content.

[Corina]

Thank you all for the responses. I was able to clear the cells and publish the list.

[TMS]

You're welcome.



If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.