Comparing values using formula / function
 

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.

Comparing values using formula / function
 

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.