Ask Your Question
0

Data imported changes cell [closed]

asked 2018-02-04 15:54:53 +0100

nfuschini gravatar image

updated 2020-08-08 17:50:04 +0100

Alex Kemp gravatar image

I have imported data from coinmarketcap, its fine and dundee, live and refreshes every 60s. My problem is that the table isnt neat at all and has lots of data that i just dont need. I then pushed the whole thing down the bottom of the file, and created a new table cleaner, easier to read, with only the information(coin prices) I need on it, and put in the cells the formula to just mirror the ones on the live table down the page eg (=E150) or something. The problem is that some of the data changes up and down the ranking from 1 to 100 on the live table, and since the cell formula is to copy an exact cell, then when that changes, the values become value from incorrect cells.... does anyone know how to fix this ??

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-08-08 17:50:11.322355

2 Answers

Sort by » oldest newest most voted
0

answered 2018-02-04 21:51:15 +0100

m.a.riosv gravatar image

Using VLOOKUP() function should help to solve your question. VLOOKUP help

edit flag offensive delete link more
0

answered 2018-02-06 22:31:30 +0100

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

thank you very much, all sorted. ;)

edit flag offensive delete link more

Question Tools

1 follower

Stats

Asked: 2018-02-04 15:54:53 +0100

Seen: 55 times

Last updated: Feb 06 '18