Forum Discussion
Data rearranging problem
Hello, Riny_van_Eekelen,
This is cryptocurrency data I want to store via API from two different exchanges (Binance and WazirX in Sheet 1 and Sheet 2 respectively). Then, I made a new worksheet to compare the prices between both. I used a formula to get the values of particular cryptocurrencies from the previous two worksheets. But due to the rearrangement of the rows of cryptos in the first two worksheets, the formula throws errors and wrong values. How can I freeze the rows to the cryptocurrencies so they don't shuffle between themselves?
Thank You
oshin7695 Thanks for sharing the file. Don't think that will ever work. You just linked every cell in the "Combined" sheet to selected cells in the PQ generated tables.
You'll need a table connecting the two and do the calculations in PQ or perhaps with a pivot table. I started something in the attached file, but don't really understand what you are doing. Perhaps it can get you started. If not, I'm afraid I can't help you any further.
Thank you, Riny_van_Eekelen. Your suggestions helped me.
