Hi Sun,

Your English is fine.

Let me see if I understand the question.


If your data looks like this

| A | B | C | D | E | F |
1|
2| XXX5565
3| PR11 100.1 EUR xxx xxx
4| PR11 100.1 EUR xxx xxx
5| PR11 100.1 EUR xxx xxx
6|
7| XXX3234
8| PR11 100.1 EUR xxx xxx
9| PR11 100.1 EUR xxx xxx
10| PR11 100.1 EUR xxx xxx

In cell A2 enter formula =IF(B2<"PR11",B2,A1)
Copy down.
Copy and paste as values, then use AutoFilter or a pivot table to find
maximum date for each material number.

Or, perhaps you can identify material number like this
=IF(LEFT(B2,3)="XXX",B2,A1)

HTH

Ed Ferrero
www.edferrero.com