advice Excel cleanup approach

Need advice on whether my Excel cleanup approach was the best solution

I was asked at work to modify an Excel table with 10 columns. Half of the columns contained company-related data, while the other half contained agent-related data.

The requirement was a bit specific:

Company rows could still repeat and needed to stay in the dataset.

But the agent-side data should not be counted multiple times if it was duplicated, because it was affecting totals and making the agent calculations inaccurate.

What I ended up doing was:

Using the agent-related text columns to identify duplicate rows.

If a row was considered a duplicate from the agent side, I set the quantity/numeric values for the duplicated agent data to 0.

After that, I made those duplicate cells white in Excel so they wouldn’t stand out visually.

It works for the totals/calculations now, but I’m wondering if this was actually a good approach or if there’s a cleaner/more professional way to handle this in Excel or Power Query?