Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hello'
i have afiled that its name is status_code.
this filed contian alot of codes' for exsamle:KB,KE,KD,G3,G4,G7,X,Z4...
i want to make group/famlies of code.
i need it becasue i have to count them in groups.
i also need to shw the barcodes that got status codes according to the groups/
the filed of the barcode calld Track_No
barcode | status_code |
---|---|
1234 | G3 |
5678 | KB |
9102 | kd |
987 | z4 |
G3, Z4 =group1
kb,kd=group2
May be this?
If(Match(status_code, 'G3','Z4'), 'group1' ,If(Match(status_code,'kd','z4'), 'group2'))