I am having a problem getting my vending machine sheet to work properly & would appreciate any help.
The sales sheet is usually filled with a copy/paste from an online report (html). Other columns have irrelevant data but I want to extract from the H column. The items are listed in format "00xx(x.xx)". This shows a sale of item 00xx for cost (x.xx). Sometimes there are up to 3 items sold at once possibly with different item numbers & prices ex. "00xx(x.xx), 00xx(x.xx), 00yy(y.yy)"
Costs & product placement vary on different machines but only 1 machine will be analyzed at a time. I would like to extract the price associated with the item sold. I seem to be on the right track but I don't know how to fix this error.
A1 shows product 0000(1.00) & A2 tells me 6 were sold.
B1 & B2 (item 0002) work
C1 does not work properly to tell me with item was sold in C2
Again, any help would be appreciated. Thanks.
Bookmarks