Please consider my attachment.
I have a file with 20500 rows.Now I want search a word,e.g."Mirror".But through filter it is not possible to find all Mirror in one shot.The error is appearing that more than 10000 unique items.
Is there any solution through Excel or in VBA world ?
Bookmarks