View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Biff Biff is offline
external usenet poster
 
Posts: 1,688
Default Can a column of data be searched from bottom to top

What do want to do when you find the marker?

Biff

"Macmoose" wrote in message
...
I have a significant amount of data that is date and time ordered. I would
like to search the last column of this data for a marker that I have
manually
inserted at certain data points. The trick is, however, that I want to be
able to search from the end of the column towards the beginning, stopping
the
search at the first occurance of the marker. Can't seem to find a
function
capable of this? Does anyone know how I can manipulate the 2003 Excel
functions to accomplish this, or am I going to have to try a different
approach?