To classify a group of number

[Dewdrop]

Dear friends,

I would like to classify certain accounts codes, appreciate someone could help me. Please refer attachment.

Thanks and kind regards
Dewdrop

[Ron Coderre]

Using your posted workbook, try this regular formula, copied down:

Please Login or Register  to view this content.

Does that help?

[Dewdrop]

Dear Ron Coderre,

Wow, it's what i was looking for! Thanks so much for your prompt reply. Fantastic!

Kind regards
Dewdrop