software

Hi Alll

I have a whole heap of raw data that is set up like this

ACCOUNTDATEPART-NOQTYSALES
MB 23/01/20046001155
MB 15/03/20056001159
MB 1/10/20036004144
MB 7/12/200460041110
MB 7/05/200360091111
MB 27/08/200360091112
I need to somehow delete or filter data and only show the most recent
sale of one particular part number, so I need it to look like
this

MB 15/03/20056001159
MB 7/12/200460041110
MB 27/08/200360091112

Please any help would be much appreciated.

Thanks
Andrew--
koba
------------------------------------------------------------------------
koba's Profile: www.excelforum.com/member.php...oamp;userid=28639
View this thread: www.excelforum.com/showthread...hreadid=506607I would make sure that the data is sorted so that the latest date is at the
bottom of each group.

Then I'd put this formula in F2:
=IF(COUNTIF(C3:$C$65536,C2)=0,quot;keepitquot;,quot;Delete itquot;)
And drag down

Then filter to show the quot;deleteitquot; rows.
delete those visible cells.

Then delete that helper column.

koba wrote:
gt;
gt; Hi Alll
gt;
gt; I have a whole heap of raw data that is set up like this
gt;
gt; ACCOUNT DATE PART-NO QTY SALES
gt; MB 23/01/2004 6001 1 55
gt; MB 15/03/2005 6001 1 59
gt; MB 1/10/2003 6004 1 44
gt; MB 7/12/2004 6004 1 110
gt; MB 7/05/2003 6009 1 111
gt; MB 27/08/2003 6009 1 112
gt;
gt;
gt;
gt; I need to somehow delete or filter data and only show the most recent
gt; sale of one particular part number, so I need it to look like
gt; this
gt;
gt; MB 15/03/2005 6001 1 59
gt; MB 7/12/2004 6004 1 110
gt; MB 27/08/2003 6009 1 112
gt;
gt; Please any help would be much appreciated.
gt;
gt; Thanks
gt; Andrew
gt;
gt; --
gt; koba
gt; ------------------------------------------------------------------------
gt; koba's Profile: www.excelforum.com/member.php...oamp;userid=28639
gt; View this thread: www.excelforum.com/showthread...hreadid=506607

--

Dave Peterson