I have a list of over 1,000 items. I want to search for the latest occurance of a word, but when I search, Excel starts at line 1, meaning I have to click past a lot of items to get to the one I want.
Can I make it start at the end?
Replies (6)
Please login or register to join the discussion.
Find All, instead of Find Next
In the Find box, instead of hitting 'Find Next' hit 'Find All' this will give you a list of all the occurances in the sheet, just below the search field, they should come up in cell order so you can just scroll to the bottom and see the last one on the list.
You will probably need to extend the search box to see all the entries, save you scrolling through the list.
That's the only way I know, but it works.
You will need to use the Lookup function.
There is a post here regarding how to do it - http://www.excelforum.com/excel-general/696592-searching-from-bottom-to-top-with-match.html
I agree with Tang-Jess!
To add a point. You can copy and paste values you find in to a separate sheet and can sort them by dates
That would have been my other suggestion
Always doing that to make sure I don't make a mess of my original sheet.
No, you are sorting your original sheet, but the values you find in to a separate sheet, so that you could easily see the order, or you do not need to copy the find values. You can scroll down and up and see in the values find window