Forum Discussion
Solved
Formulas and Functions
Dear Everyone, Riny_van_Eekelen Would you please help me with the following formula, A B C Particulars Criteria Result 1 101010100000 If 1st digit of Cell A...
Oliullah_Siddique You can do that in several ways. I've included just two of them in the attached workbook. It all depend a bit on how much data yo have, how often you need to change codes etc.
In general, I prefer the solution with a lookup table. The formula get easier to write and read and it easier to maintain.
Oliullah_Siddique You can do that in several ways. I've included just two of them in the attached workbook. It all depend a bit on how much data yo have, how often you need to change codes etc.
In general, I prefer the solution with a lookup table. The formula get easier to write and read and it easier to maintain.
