Aug 06 2021 09:45 AM
Category | Driving Authority |
A | Motorcycle, Moped, Scooter |
B | Car, jeep, Delivery Van |
C | Tempo, Auto Rickshaw |
C1 | E-Rickshaw |
D | Power Tiller |
E | Tractor |
F | Minibus, Minitruck |
G | Truck, Bus, Lorry |
H | Road Roller, Dozer |
H1 | Dozer |
H2 | Road Roller |
I | Crane, Fire Brigade, Loader |
I1 | Crane |
I2 | Fire Brigade |
I3 | Loader |
J1 | Excavator |
J2 | Backhoe Loader |
J3 | Grader |
J4 | Forklift |
J5 | Other |
K | Scooter, Moped |
make a function or formula or vba, for the following condition.
I have to write the category in the same cell with comma for example see below.
A, B |
The the driving authority must come automatically in the other cell as below:
Motorcycle, Moped, Scooter, Car, jeep, Delivery Van |
I may need to write up to 7 category In the same cell.
please make a formula for it.
Aug 06 2021 09:53 AM
@songgum And what's the logic behind all of this?
Aug 06 2021 09:55 AM
@Riny_van_Eekelen I have to make report on the driving authority of the person where i work.
Aug 06 2021 10:03 AM
@songgum Sorry, but what's the logic for combining the entries for A and B into a string like "Motorcycle, Moped, Scooter, Car, jeep, Delivery Van". What's the next string you want an based on which rules?
Aug 06 2021 10:48 AM
With the permission of everyone involved, here is an example to unfold for yourself.
Please see the inserted file.
Thank you for your patience and time.
Nikolino
I know I don't know anything (Socrates)
Aug 06 2021 11:35 AM
=TEXTJOIN(", ",TRUE,XLOOKUP(FILTERXML("<y><z>"&SUBSTITUTE(E1,",","</z><z>")&"</z></y>","//z"),A1:A14,B1:B14))
Aug 06 2021 07:53 PM
Aug 06 2021 08:14 PM
Aug 07 2021 06:45 AM
Column A contains the Category and column B contains the Driving Authority. E1 contains the search criteria.