woodardhsd
New Member
- Joined
- Nov 4, 2017
- Messages
- 1
I have a spreadsheet with two columns. One has prices from a website, one has the prices from my vendor. The vendor prices column has text in it that defines the quantity. For example, 9.99 / Case , of 15.99/bag. I need to compare the website price to the vendor price, but exclude the text. Is this possible?
Here is a small piece of the spreadsheet. For each row (using the first line as an example), I just want to divide 115 by 55.81. The result would go in the next column.
I googled everything I could think of, I must be calling what I am looking for by the wrong name.
Thanks,
Mike
Here is a small piece of the spreadsheet. For each row (using the first line as an example), I just want to divide 115 by 55.81. The result would go in the next column.

I googled everything I could think of, I must be calling what I am looking for by the wrong name.
Thanks,
Mike