Consoildating Rows

[koba]

Hi Alll

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

ACCOUNT DATE PART-NO QTY SALES
MB 23/01/2004 6001 1 55
MB 15/03/2005 6001 1 59
MB 1/10/2003 6004 1 44
MB 7/12/2004 6004 1 110
MB 7/05/2003 6009 1 111
MB 27/08/2003 6009 1 112



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/2005 6001 1 59
MB 7/12/2004 6004 1 110
MB 27/08/2003 6009 1 112

Please any help would be much appreciated.

Thanks
Andrew

[Dave Peterson]

I 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,"keepit","Delete it")
And drag down

Then filter to show the "deleteit" rows.
delete those visible cells.

Then delete that helper column.

koba wrote:
>
> Hi Alll
>
> I have a whole heap of raw data that is set up like this
>
> ACCOUNT DATE PART-NO QTY SALES
> MB 23/01/2004 6001 1 55
> MB 15/03/2005 6001 1 59
> MB 1/10/2003 6004 1 44
> MB 7/12/2004 6004 1 110
> MB 7/05/2003 6009 1 111
> MB 27/08/2003 6009 1 112
>
>
>
> 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/2005 6001 1 59
> MB 7/12/2004 6004 1 110
> MB 27/08/2003 6009 1 112
>
> Please any help would be much appreciated.
>
> Thanks
> Andrew
>
> --
> koba
> ------------------------------------------------------------------------
> koba's Profile: http://www.excelforum.com/member.php...o&userid=28639
> View this thread: http://www.excelforum.com/showthread...hreadid=506607

--

Dave Peterson