Hi, I have a spreadsheet of data. Mine has 275 rows. Another team gives me their information which I paste onto the bottom (they have 750 rows). I pasted this data at the bottom and all seemed fine…until I removed their duplicates. This should have removed 20 rows (for their total of 730 and an overall of 1005). Instead, it keeps deleting extra rows. Instead of 730, it only includes 690. Why is this happening? How can I stop it? I’ve already massaged their data quite a bit so I can’t go back to their original source. I can just reference it to know I’m missing 40 rows, of which I have no idea what they are.