I am currently working on an excel file and I am stuck with two formulas. Attached you can find a file in which you can find the formulas that are not working as I want, to be marked red (column E and N).
First, I want the formula in column E to display a "1" if the cell in column C or D contains the text "0-jewel", "1-jewel", ..., "10-jewel". However, it displays a "1" for almost all observations because it counts, for example, "22-jewel" as "2-jewel". I want to overcome this problem, but I don't know exactly how to do this. I think the formula I use for columns E untill L is not the most efficient one either.
Second, I have a similar problem regarding the formula in column N. Same problem, but now with milimeters (mm) instead of -jewels.
Can somebody please help me rewrite this to an efficient formula?
Kind regards,
Bas van den Boomen
Bookmarks