Jase Alexander
asked on
Excel Converting a text entered sum into value with multiple entry criteria
Hi Experts
Hope you can help
We ahve packing lists sent from our suppliers to check for carton compliance; data that is entered into Column H on the atatached example. This entry is normally entered as dimensions LxWxH and, for example, looks either as 50*30*20 or 50x30x20
In order to check conformity, I would like to put a formula in Column K to sum the carton dimesions entry however it is normally in text and as you can see above, either separated by a * or an x
Ive tried using VALUE and ISNUMBER with a combination of extracting the values to sum the entries (that I will then look up to the correct available sizes) but to now, I cannot find a suitable solution
I have attached an example
Any help would be greatly appreciated
J
EE_Example.xlsx
Hope you can help
We ahve packing lists sent from our suppliers to check for carton compliance; data that is entered into Column H on the atatached example. This entry is normally entered as dimensions LxWxH and, for example, looks either as 50*30*20 or 50x30x20
In order to check conformity, I would like to put a formula in Column K to sum the carton dimesions entry however it is normally in text and as you can see above, either separated by a * or an x
Ive tried using VALUE and ISNUMBER with a combination of extracting the values to sum the entries (that I will then look up to the correct available sizes) but to now, I cannot find a suitable solution
I have attached an example
Any help would be greatly appreciated
J
EE_Example.xlsx
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Happy to help.
ASKER
Thank you so much for your help and these invaluable options
Cant thank you enough
Jase