Excel - searching upwards

Posted by Constantly Confused PM | on Mon, 20/08/2012 - 09:40 637 6 comments | report

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?

Comments

There are 6 comments. Login or register to view them.

Find All, instead of Find Next

tang-jess | Mon, 20/08/2012 - 10:50

You will need to use the

merlyn | Mon, 20/08/2012 - 11:11

I agree with Tang-Jess!

Cantona1 | Tue, 21/08/2012 - 14:59

That would have been my other suggestion

tang-jess | Tue, 21/08/2012 - 17:31

Sort

petersaxton | Tue, 21/08/2012 - 20:38

No, you are sorting your

Cantona1 | Tue, 21/08/2012 - 20:58