How to get the last row in from multiple groups of data?

[ncsthbell]

I am running windows xp, ms office 2000. I have an application that has data that looks like this:

FuelType  Year   State   (column names,all keys, so no dups allowed)
Diesel    1999     NC
Diesel    2000     NC
Diesel    2001     NC
Gas       1998     SC
Gas       1999     SC
Gas       2000     SC

What I am trying to do is to select the last row in the each set of keys, basically, I want one row for each FuelType, Year & State. So, for NC, I would get the row for Diesel 2001, for SC I would get Gas for 2000. Maybe I am over compliating this but I am trying to use the 'max' function and can not get the results I need. There are other columns of data on the record I will need once I can determine which is the last row for this grouping. Any guidance would be appreciated!!!!

[NeoPa]

This is possible. Unfortunately your example seems to contradict your explanation, so I'm not sure what you're after here (Is it max year for each FuelType / State combination? Or max FuelType / Year for each State as per your example explanations?).

Please clarify and then we can proceed.