Well....I tried with the first formula...and that's perfect!

Thanks a million for your help Ed, you really made me saving time!


--
Dawns are only the illusion of the beauty of the world. When the world opens
eyes, reality takes back its rights.


"Ed Ferrero" wrote:

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