Romano_odK
Active Member
- Joined
- Jun 4, 2020
- Messages
- 379
- Office Version
- 365
- Platform
- Windows
Good afternoon,
In a table I have the columns C until O who are filled from a SQL after a refresh. In that refresh some cells are filles with a "zero". Is it possible to erase all the cells where there is only one zero?
Thank you for you time and efforts.
In a table I have the columns C until O who are filled from a SQL after a refresh. In that refresh some cells are filles with a "zero". Is it possible to erase all the cells where there is only one zero?
Thank you for you time and efforts.
Directory: | C:\temp\100MRP.xml | Last refresh | Date | Week | ||||||||||
22/02/2024 17:00 | 22/02 | 8 | ||||||||||||
Artikelcode | Omschrijving | 02/2023 | 03/2023 | 04/2023 | 05/2023 | 06/2023 | 07/2023 | 08/2023 | 09/2023 | 10/2023 | 11/2023 | 12/2023 | 01/2024 | 02/2024 |
itemcode | description | q-12 | q-11 | q-10 | q-9 | q-8 | q-7 | q-6 | q-5 | q-4 | q-3 | q-2 | q-1 | q-0 |
100000 | Vito Glaserfix 111 6x2 mm wit - 10x25 m | 16 | 16 | 16 | 16 | 50 | 18 | 21 | 5 | 32 | 13 | 17 | ||
100001 | Vito Glaserfix 111 6x2 mm zwart - 10x25 m | 80 | 16 | 36 | 16 | 26 | 17 | |||||||
100002 | Vito Glaserfix 111 6x3 mm wit - 10x25 m | 80 | 62 | 17 | 32 | 48 | 18 | 37 | 16 | 32 | 3 | 32 | ||
100003 | Vito Glaserfix 111 6x3 mm zwart - 10x25 m | 48 | 21 | 1 | 21 | 16 | 32 | 16 | 21 | 17 | 7 | |||
100004 | Vito Glaserfix 111 6x4 mm wit - 10x25 m | 16 | -16 | 16 | 16 | |||||||||
100005 | Vito Glaserfix 111 6x4 mm zwart - 10x25 m | 16 | -16 | 16 | ||||||||||