MAKE SOME CODE/VALUES AS ONE GROUP

[y_vandijk]

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

[Anil_Babu_Samineni]

May be this?

If(Match(status_code, 'G3','Z4'), 'group1' ,If(Match(status_code,'kd','z4'), 'group2'))