Forum Discussion
Categorizing the below range for entire column into header wise.
Categorizing the below range for entire column into header wise. Range starting with 10000 goes to ABC, likewise.
Example.
10009 |
10010 |
10011 |
10020 |
33921 |
33930 |
33990 |
63098 |
63099 |
63554 |
74144 |
74991 |
75600 |
78213 |
Convert to
ABC |
10009 |
10010 |
10011 |
10020 |
XYZ |
33921 |
33930 |
33990 |
EFG |
63098 |
63099 |
63554 |
HIJ |
74144 |
74991 |
75600 |
78213 |
- Thanks, Patrick, for the solution, can you please explain me the first sheet, where you have defined. =MUNIT(20) and how to bring that to 2nd sheet?
Here is a solution, if I understand your issue.
With the left function, you will get the first number of your argument. Multiply it by one in order to have it as a value.
Second, create a table showing that number 1 = ABC, 2 = DEF etc.
Third, with an xlookup, associate the number to the code.
Fourth, create a pivot table appropriately
Fifth, copy as values if necessary
Hope it helps
Thanks durendal for sharing the solution, I must say that so quick.
