Forum Discussion
Solved
Remove Duplicates - Weird Behavior
I have one column with 200 lines of data in it. Let's call it range P33:P232. I want to remove all the duplicates in that data but keep the original data where it is, so I copy that range and paste...
Hi HN,
My first inclination is to ask if there were any hidden rows where you are pasting to or from.
Hi HN,
My first inclination is to ask if there were any hidden rows where you are pasting to or from.
I was thinking someone was going to ask that. I checked for it initially and thought there we no hidden rows. After checking again, there were hidden rows >_< Wow what a duh answer. Thank you for your help!
