Hello,
I have attached an Excel file depicting what i need help with.
In the product name, connected to another system, is the weight of the product.
I'm attempting to see how many grams the product is selling per inhabitant. I used the =MID formula for this before, but the next batch of products have different lengths to the product name leading up to the gram part, thus giving me some problems. The ultimate solution is one that will be easy to do again for a different batch of products, as there are many more products to go.
Hopefully you will understand what i'm after once you have looked at the Excel file. To the right on the file is an example of how I did it when the product name was the same, and to the left is how it would look if I applied the same formula to the new products with different lengths. As the information is tied to another system, I'm afraid that changing names of the products would ultimately lead to the information not being updated once new sales reports have come in. I'm looking at how many grams each product is selling in each country and ultimately grams per inhibitant of that said country.
Thankful for any help!
Bookmarks