Romano_odK
Active Member
- Joined
- Jun 4, 2020
- Messages
- 380
- Office Version
- 365
- Platform
- Windows
Good morning,
In the column E "Geldig tot" there are dates. If you look at column A you see the same item codes (Artikelcode). Now I need to see only the newest date, so only one item code with the newest date. Is that possible to filter out and delete the rest?
Thank you for your time.
In the column E "Geldig tot" there are dates. If you look at column A you see the same item codes (Artikelcode). Now I need to see only the newest date, so only one item code with the newest date. Is that possible to filter out and delete the rest?
Thank you for your time.
Book1 | |||||||
---|---|---|---|---|---|---|---|
A | B | C | D | E | |||
1 | Artikelcode | Omschrijving | Eenheid | Geldig van | Geldig tot | ||
2 | 100000 | Vito Glaserfix 111 6x2 mm wit - 10x25 m | pak | 01/07/2020 | 11/04/2021 | ||
3 | 100000 | Vito Glaserfix 111 6x2 mm wit - 10x25 m | pak | 12/04/2021 | 21/04/2021 | ||
4 | 100000 | Vito Glaserfix 111 6x2 mm wit - 10x25 m | pak | 22/04/2021 | 30/06/2021 | ||
5 | 100000 | Vito Glaserfix 111 6x2 mm wit - 10x25 m | pak | 01/07/2021 | 14/10/2021 | ||
6 | 100000 | Vito Glaserfix 111 6x2 mm wit - 10x25 m | pak | 15/10/2021 | 02/01/2022 | ||
7 | 100000 | Vito Glaserfix 111 6x2 mm wit - 10x25 m | pak | 03/01/2022 | 31/01/2022 | ||
8 | 100000 | Vito Glaserfix 111 6x2 mm wit - 10x25 m | pak | 01/02/2022 | 30/05/2022 | ||
9 | 100000 | Vito Glaserfix 111 6x2 mm wit - 10x25 m | pak | 31/05/2022 | 31/12/2299 | ||
10 | 100001 | Vito Glaserfix 111 6x2 mm zwart - 10x25 m | pak | 01/07/2020 | 11/04/2021 | ||
11 | 100001 | Vito Glaserfix 111 6x2 mm zwart - 10x25 m | pak | 12/04/2021 | 22/04/2021 | ||
12 | 100001 | Vito Glaserfix 111 6x2 mm zwart - 10x25 m | pak | 23/04/2021 | 30/06/2021 | ||
13 | 100001 | Vito Glaserfix 111 6x2 mm zwart - 10x25 m | pak | 01/07/2021 | 14/10/2021 | ||
14 | 100001 | Vito Glaserfix 111 6x2 mm zwart - 10x25 m | pak | 15/10/2021 | 02/01/2022 | ||
15 | 100001 | Vito Glaserfix 111 6x2 mm zwart - 10x25 m | pak | 03/01/2022 | 31/01/2022 | ||
16 | 100001 | Vito Glaserfix 111 6x2 mm zwart - 10x25 m | pak | 01/02/2022 | 30/05/2022 | ||
17 | 100001 | Vito Glaserfix 111 6x2 mm zwart - 10x25 m | pak | 31/05/2022 | 31/12/2299 | ||
18 | 100002 | Vito Glaserfix 111 6x3 mm wit - 10x25 m | pak | 01/07/2020 | 11/04/2021 | ||
19 | 100002 | Vito Glaserfix 111 6x3 mm wit - 10x25 m | pak | 12/04/2021 | 30/06/2021 | ||
20 | 100002 | Vito Glaserfix 111 6x3 mm wit - 10x25 m | pak | 01/07/2021 | 14/10/2021 | ||
21 | 100002 | Vito Glaserfix 111 6x3 mm wit - 10x25 m | pak | 15/10/2021 | 02/01/2022 | ||
22 | 100002 | Vito Glaserfix 111 6x3 mm wit - 10x25 m | pak | 03/01/2022 | 31/01/2022 | ||
23 | 100002 | Vito Glaserfix 111 6x3 mm wit - 10x25 m | pak | 01/02/2022 | 30/05/2022 | ||
24 | 100002 | Vito Glaserfix 111 6x3 mm wit - 10x25 m | pak | 31/05/2022 | 31/12/2299 | ||
25 | 100003 | Vito Glaserfix 111 6x3 mm zwart - 10x25 m | pak | 01/07/2020 | 30/06/2021 | ||
26 | 100003 | Vito Glaserfix 111 6x3 mm zwart - 10x25 m | pak | 01/07/2021 | 14/10/2021 | ||
27 | 100003 | Vito Glaserfix 111 6x3 mm zwart - 10x25 m | pak | 15/10/2021 | 02/01/2022 | ||
28 | 100003 | Vito Glaserfix 111 6x3 mm zwart - 10x25 m | pak | 03/01/2022 | 31/01/2022 | ||
29 | 100003 | Vito Glaserfix 111 6x3 mm zwart - 10x25 m | pak | 01/02/2022 | 30/05/2022 | ||
30 | 100003 | Vito Glaserfix 111 6x3 mm zwart - 10x25 m | pak | 31/05/2022 | 31/12/2299 | ||
Query1 |