Mati44
02-02-2018, 11:45 AM
Hi Everybody,
I have a set of values, each start with a letter (either A,B,C or D), and a number after that as can be seen in the example worksheet attached. I want to group them according to the first letter they start with. I made an example in the attached worksheet. There are some formulas for this type of work but they don't work in this case. I'd really appreciate any help. Thanks!!
21517
21520
I have a set of values, each start with a letter (either A,B,C or D), and a number after that as can be seen in the example worksheet attached. I want to group them according to the first letter they start with. I made an example in the attached worksheet. There are some formulas for this type of work but they don't work in this case. I'd really appreciate any help. Thanks!!
21517
21520