I have a list of song titles. If filter for "Longfellow Serenade". My filter shows two identical "Longfellow Serenade"s. I select both.
My sheet now shows two lines, with "Longfellow Serenade" on each line. I check each one for blanks, special characters, etc. They're both identical. But, to be sure, I copy the top one and paste it into the second one. So, my filter list should have only 1 "Longfellow Serenade" to select now, right?
Nope, filter list shows two identical "Longfellow Serenade"s.
I select the first; the two lines I got earlier appear. Hmmm!
I clear the filter.
I filter again, filter list shows two identical "Longfellow Serenade"s.
I select the second; the two lines I got earlier appear. Hmmm! What's going on here?
My worksheet has 24K lines, if I delete lines, the problem disappears, so it's not going to help to post an example.
Any ideas?
Bookmarks