For your #1, check out the "Arbitrary Lookups" section of this page:
http://www.cpearson.com/excel/lookups.htm
HTH,
JP
On Dec 13, 2:01 pm, Rothman wrote:
I'm thinking this isn't possible, but thought I'd float it out to see if
anyone had any ideas. I have the following columns of data (an excerpt;
there's about 300 records in my table):
TimeID Num1 Num2
1 4 4
2 5 4
3 6 2
4 5 3
5 3 3
6 4 4
7 4 3
8 6 2
------------------------------
9 5 4
Is there a single formula that can:
1) find the most recent values for each, unique Num1 (e.g. for Num1=6, it'd
be TimeID=8),