PDA

View Full Version : [SOLVED] Code Products



Romulo Avila
04-12-2017, 02:35 PM
Good evening,
I have a spreadsheet where in column B I need to create a formula that sorts the products as follows.
- If it contains the characters "-BC-" or "-CD-" which classifies using the first 02 characters plus the letters;
- In cases where you do not have these characters that search only the first 02 digits;

In case it does not contain the characters, I can use the formula left (a1,2), but in the case that contains the characters I tried to use the formula SEARCH but I could not, I wanted to use only one formula ..

Thank you for your help

18919

p45cal
04-12-2017, 04:50 PM
18921

Romulo Avila
04-13-2017, 04:28 AM
Good Morning,
I made the formula, but according to the image below, there is an error.

18926

p45cal
04-13-2017, 05:12 AM
It was all working here when I tested it.
It just goes to show that supplying a file is so much better than suplying an image, then you'd get a file back with a working formula, rather than an image of a formula. If there are any language/locale problems, that's often sorted by using a file, as well saving people who are helping you time by not having to retype an image into a spreadsheet, and if there are any idiosyncrasies in the file, that will be seen by the helper too.

Supply a file rather than a picture.

Romulo Avila
04-13-2017, 05:39 AM
Good Morning,

Follows as requested.

Thank you

p45cal
04-13-2017, 07:05 AM
You moved some brackets around!
See attached.