Dear all,
I have a tricky problem in excel that I couldn't find a solution yet.
I have a list of coin description copied form a website with price, date, grade, services etc. I would like to extract the price, the date and the grade for each coin from the list, so that I can eventually plot the coin prices vs time.
Anyone has an idea what the best way to do this is? I have tried to extract the value of every x row, but unfortunately the data is not spaced regularly. The best way would probably be some kind of command: extract value for all cells starting with "sold for", but not sure what that would be.
It would be great if someone can help!
Bookmarks