Hello all,
First time posting, so thank you in advance for reading.
I'm stuck with what seems like it should be a simple problem to solve. I have two very long lists that I want to compare. I'm using "Filter" under the "Data" tab to filter the results of List A, to get a shortened list. Next, I want to simply copy the short list and paste it to a separate spreadsheet to compare for duplicates.
However, when I attempt to paste the results of List A to List B, only some of the results show up. To demonstrate what I mean, please see the example image attached with this message. All 9 results should copy over from Column A to Column I. However, this does not occur. Only Rows 3-9 copy over.
How can I copy/paste all of the filtered results? Using "Alt ;" or selecting "Visible cells only" under "Go to Special" does not work either. Any idea what I'm doing wrong here? Thanks
Bookmarks