Hello Everyone,

I use MS Excel but would consider myself a novice. I'm working on something where I have two CSV exports from different databases. The output is a list of server hostnames and several other attribute columns. One list has about 10,000 rows and the other is roughly 5000 rows. What I need to do is compare the hostnames from the two CSVs and keep the duplicates and discard any hostname where there isn't a match. I also need to keep the associated attribute columns in place. In addition to this, the hostnames on one of the exports will most likely be fully qualified, whereas it would be a short on the other.

I'm pretty sure this is possible, I'm just curious about how complex it is ... Does anyone have any ideas? Any advice would be appreciated. Thank you.

If this should be in a different forum, let me know and I'll move it. Thx!