=MAX((A2:A20=11647)*(F2:F20))

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"mikefranklin1969" wrote in
message ...
I have imported a query into excel and I'm having a problem sorting the
data.
The data consists of part #, description, technician #, usage qty, and
usage
date. I am trying to find the last used date for each part #. The
imported
query gives every used qty of every part and looks something like this:
A B C D
E
=MAX((A2:A20=11647)*(F2:F20))
I can do a pivot table on another sheet and sort by tech number or part
number and get some sort of organization, but I'm only interested in
knowing
the last time a part was used. I've tried inserting a formula into
F2=if(E2<051212,"Over 6 months ago","") and so on, which organizes the
part
usage into a few useable types, but I can't seem to organize it down to
the
last uasage. Any tips or hints would be great.