Excel Formula
Budget: $30 – $250 AUD
Column B is description
Last characters of each line is what i call the carton inner and outer czrton quantity
Example alb 288991 is 24/12
This means outer is 24 and inner is 12 as per my manual entry in columns k and l
I want a formula that will extract all of this information into k and l
I will be reusing this formula regularly into updated versions of spreadsheet
Full spreadsheet is around 7500 lines
Please advise price to create formula
Thanks
mark
Last characters of each line is what i call the carton inner and outer czrton quantity
Example alb 288991 is 24/12
This means outer is 24 and inner is 12 as per my manual entry in columns k and l
I want a formula that will extract all of this information into k and l
I will be reusing this formula regularly into updated versions of spreadsheet
Full spreadsheet is around 7500 lines
Please advise price to create formula
Thanks
mark
Related categories:
Flex