Extracting specific values from excel sheet

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!

You could use vba something like this...

Please Login or Register  to view this content.

This helped! Amazing, thank you so much!

No problems.