I'm currently scanning our network for software installs to make sure we're licence-compliant but I have to do several scans to make sure I get all the laptops that come and go, those that didn't respond because of firewalls etc. which leaves me with several Excel sheets I need to merge with a lot of the same data. Is there an easy way to remove duplicate rows in Excel where /all/ the cells are the same?
I will eventually be databasing the living /shit/ out of it, but it would be far easier for me if I have Excel sheet right before I upload it.
TIA
MIA
BYOB