View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
MSSailor MSSailor is offline
external usenet poster
 
Posts: 15
Default How to find a row with latest date and its values

Have an basic info in "sheet A" with columns named like below, with hundreds
of rows with data:
Date,Flightnr, Aircraft, Dep.Airport, Arr.Airport, Flighttime etc etc

In "sheet B" I have a form that I want to present the latest flight

The last flight (most previous) was:
Date, Flight, Aircraft, Dep.Airport, Arr.Airport, Flighttime