Hello everyone, new here and extremely new to Excel. Been copying from other documents and editing to learn, however, I've gotten stuck.
The idea behind the Spreadsheet is as follows: There is a column that is automatically updated every 30 mins with marketplace data from an API (already working). When this price goes up I'd like another column to record that new price, however, if the price was to go down, it would stay the same. So:
1st column- Market price: 2,500,000 silver / 2nd column- Max price: 2,500,000 silver
30mins later >
1st column- Updated Market price: 2,000,000 silver / 2nd column- Max price: 2,500,000 silver (stays the same since the updated price is lower)
Thanks in advance!
Bookmarks