I have a spreadsheet with the following data

00000003 223,000.00 03/01/05
00000003 238,610.00 07/01/05
00000003 253,881.04 07/01/06
00000006 727,275.00 10/01/04
00000006 778,184.25 07/01/05
00000006 827,988.04 07/01/06
00000007 180,725.00 01/01/05
00000007 193,375.75 07/01/05
00000007 201,110.78 01/01/06
00000007 206,800.00 02/01/06
00000007 220,035.20 07/01/06
00000012 210,627.00 01/01/05
00000012 225,370.89 01/01/06
00000012 239,794.63 07/01/06
00000027 225,000.00 01/01/05
00000027 238,500.00 07/01/05
00000027 251,379.00 07/01/06
00000027 261,434.16 11/01/06
00000035 200,000.00 01/01/05
00000040 183,240.00 10/01/04
00000040 196,066.80 07/01/05
00000040 208,615.08 07/01/06
00000044 89,069.00 11/26/04
00000044 89,724.00 05/01/05
00000044 96,004.68 07/01/05
00000044 102,148.98 07/01/06

I need to find the most recent value for the middle column, sorted by the
first column. The date is in the third column. IE for 00000003 I need to
return a row into a second worksheet that is 00000003 223,000.00 03/01/05.
If I sort by column 1 and then by column 3, then all I need to do is pick up
the first line after the value in column 1 changes. If I can't do this, then
I need to compare column 1 and column 3 to ensure that I get the most recent
value.

With the data sorted by first column and then third column, you can
pick up the first item in each row by selecting the first column and
choosing: DataFilterAdvanced Filter then just check unique records
only and click OK. Copy the selection to another sheet and shoose
DataFilterShow All to remove the filter.

JBS wrote:

I have a spreadsheet with the following data

00000003 223,000.00 03/01/05
00000003 238,610.00 07/01/05
00000003 253,881.04 07/01/06
00000006 727,275.00 10/01/04
00000006 778,184.25 07/01/05
00000006 827,988.04 07/01/06
00000007 180,725.00 01/01/05
00000007 193,375.75 07/01/05
00000007 201,110.78 01/01/06
00000007 206,800.00 02/01/06
00000007 220,035.20 07/01/06
00000012 210,627.00 01/01/05
00000012 225,370.89 01/01/06
00000012 239,794.63 07/01/06
00000027 225,000.00 01/01/05
00000027 238,500.00 07/01/05
00000027 251,379.00 07/01/06
00000027 261,434.16 11/01/06
00000035 200,000.00 01/01/05
00000040 183,240.00 10/01/04
00000040 196,066.80 07/01/05
00000040 208,615.08 07/01/06
00000044 89,069.00 11/26/04
00000044 89,724.00 05/01/05
00000044 96,004.68 07/01/05
00000044 102,148.98 07/01/06

I need to find the most recent value for the middle column, sorted by the
first column. The date is in the third column. IE for 00000003 I need to
return a row into a second worksheet that is 00000003 223,000.00 03/01/05.
If I sort by column 1 and then by column 3, then all I need to do is pick up
the first line after the value in column 1 changes. If I can't do this, then
I need to compare column 1 and column 3 to ensure that I get the most recent
value.