yogi_Pull Most Recent Records Based On Unique Values In A Column

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                            www.energyefficientbuild.com
user lukeacaratan said:
use query function to pull most recent records based on unique column values.

I have a table (with data populated by a form) with three columns. Col A is the Timestamp, Col B is Location, Col C is a Unit Label.

I am trying to use the query function to pull certain records from a table. My goal is to create a report that only shows the most recent entry for each unique item listed in the Column C.

My first attempt (unsuccessfully) used a combination of Vlookups to pull the specific records. After doing some research, it seems like the query function might be a better fit for what i'm trying to accomploish.

After a couple days of trying on my own, gathering knowledge from the internet, in this forum and ones like it, I can't seem to input the correct SQL. I have made the spreadsheet public and shared it below in hopes that someone can help point me in the right direction. 

https://docs.google.com/spreadsheet/ccc?key=0AjejngD4Oi-vdG5SeUU4bUlJbWZ4X1BIRG9vZERJblE

Thanks you in advance for any help!

Luke

Chrome Browser on Mac Lion with Virtual XP machine, Desktop with XP or Windows 7

-----------------------------------------

following is a solution to the problem