Excel - searching upwards

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 |

You will need to use the

merlyn |

I agree with Tang-Jess!

Cantona1 |

That would have been my other suggestion

tang-jess |

Sort

petersaxton |
petersaxton's picture

No, you are sorting your

Cantona1 |