Hi guys,
Hoping someone can help with the below problem
I have a used car stocklist with the price changes made on the internet in the below format, each price is seperated by a "."
What i need is to pull the second last price change.
So my data in column O is - 0. 1099800. 788800. 777700. 699800 - the 0 at the front is the first listing and the are no seperators for cents.
The first actual price is 10,998.00, i just want to pull 7,777.00 being the second last price change.
Hoping someone can help with the below problem
I have a used car stocklist with the price changes made on the internet in the below format, each price is seperated by a "."
What i need is to pull the second last price change.
So my data in column O is - 0. 1099800. 788800. 777700. 699800 - the 0 at the front is the first listing and the are no seperators for cents.
The first actual price is 10,998.00, i just want to pull 7,777.00 being the second last price change.