Can I search backwards from a point in the file?
 

I want to search backwards from a point in an Excel file to find the last
instance. Searching forward doesn't let me tell where the last instance is
without searching through at least twice and looking at the line numbers of
each find.

Can I search backwards from a point in the file?
 

No, not without using VBA code

"heeler" wrote:

I want to search backwards from a point in an Excel file to find the last
instance. Searching forward doesn't let me tell where the last instance is
without searching through at least twice and looking at the line numbers of
each find.

Can I search backwards from a point in the file?
 

Thanks. Not exactly what I wanted to hear, but glad to know one way or the
other.

"Sheeloo" wrote:

No, not without using VBA code

"heeler" wrote:

I want to search backwards from a point in an Excel file to find the last
instance. Searching forward doesn't let me tell where the last instance is
without searching through at least twice and looking at the line numbers of
each find.