Michelle asks this Excel question:
Is there a way to clear duplicate data in Excel but keep rows. Do not delete or remove the rows.

For example column A has company name. Column B has many dates. The amounts in column C are the same for each company. I need to keep the amount in the first row but clear the amounts in all the subsequent rows for that company.

Michelle has over 100K rows and manually deleting amounts is breaking her mind and body.

This video shows three solutions.
The easiest: data is sorted by company and the amounts never change.
Scenario 2: The data is sorted by date and not by company.
Scenario 3: One company can have two amounts.

Excel skills:
Filter in Excel
Testing if this row is the same as the row above in Excel.

Topics:
how to clear duplicates in excel
remove duplicate numbers in a column in excel
remove duplicated from a column in excel
remove duplicates using a excel formula
how remove duplicate in excel