Hi,
Maybe someone can help me with the following task?
I have an excel report, where a lot of data must be checked and altered if a list of criteria is met.
Please see the attached picture.
What do I have:
What do I have to achieve:
I need to have Repair description 1 (column Y) checked / changed from value REP to REC and value XSS to XAC if the following criteria is met:
If the criteria above are met, the Y needs to be changed for all lines in an order (column N). Order line count within the order is displayed on column H.
Any ideas would be greatly appreciated.
Image of the Excel report below:
Many thanks,
Martins
Maybe someone can help me with the following task?
I have an excel report, where a lot of data must be checked and altered if a list of criteria is met.
Please see the attached picture.
What do I have:
- I have an order number (column N)
- Repair description 1 (Column Y)
- Repair description 2 (Column AB)
- Item (column AF)
- Date A (column AP)
- Date B (column AV)
- Warranty (column BK)
What do I have to achieve:
I need to have Repair description 1 (column Y) checked / changed from value REP to REC and value XSS to XAC if the following criteria is met:
- AB is equal to „DIY”
- BK is equal to „INTR05”
- Elapsed time from the AP to AV is greater than 12 months
- AF starts with 3601* or 0601* or 3611* or 0611*
If the criteria above are met, the Y needs to be changed for all lines in an order (column N). Order line count within the order is displayed on column H.
Any ideas would be greatly appreciated.
Image of the Excel report below:
Many thanks,
Martins