Hello...
I need some help here. I am doing data validation now to check the size and the unit of the size code.
Example: TB C10 GEL 125ml
In the test1.xls, I have the data as above. I wanted to extract the 125ml out. But for the function I created, I got the results of 10gm instead of 125ml. So I just wondering is there any solutions for that. I wanna extract the 125ml without the space exist. The function can be viewed under the attachment in alt+F11
In the test3.xls, I wish to validate the size and the unit in the respective column. Example: if the size of the 1st data is same as the size of the 2nd data, the formula is able to display "MATCH" else if not equal, the formula will display "DISMATCH". I had done the formula inside the file but cannot get the results as I wanted.
Thanks for yr help! Hope to find a kind person to help me out here!
Thanks!
Below is the link of my excel file: you all can download it for reference!
http://h1.ripway.com/suaiko9999/test1.xls
http://h1.ripway.com/suaiko9999/test3.xls
I need some help here. I am doing data validation now to check the size and the unit of the size code.
Example: TB C10 GEL 125ml
In the test1.xls, I have the data as above. I wanted to extract the 125ml out. But for the function I created, I got the results of 10gm instead of 125ml. So I just wondering is there any solutions for that. I wanna extract the 125ml without the space exist. The function can be viewed under the attachment in alt+F11
In the test3.xls, I wish to validate the size and the unit in the respective column. Example: if the size of the 1st data is same as the size of the 2nd data, the formula is able to display "MATCH" else if not equal, the formula will display "DISMATCH". I had done the formula inside the file but cannot get the results as I wanted.
Thanks for yr help! Hope to find a kind person to help me out here!
Thanks!
Below is the link of my excel file: you all can download it for reference!
http://h1.ripway.com/suaiko9999/test1.xls
http://h1.ripway.com/suaiko9999/test3.xls
