To write the spec for an app or tell the AI what needs to be done. Google Sheets while being a fine thing may not have a way to write apps, macros or an AI to do what you ask.
So back to how its been done for decades. Write the spec, then the app to do what you want on demand.
Okay, for clarity, I'm attaching the image.
I have sorted out the URLs in column A based on the category in column C. But, the main problem is that the list is derived from a database and the there are duplicates of the URLs in multiple categories.
I need to identify what URL exists in what category before finding the duplicates and getting rid of those. Is there a tool for automation or is it possible to do it without human intervention.
It's not just about removing duplicates