I have a table that I import daily through power query...
and I have all my formulas to the right of the imported table.
Sometimes the table is larger or smaller (rows-wise) based on however big the table is that day from the website.
So I have my formulas down way past the most rows I know the table would be on any given day.
The problem I am having is that when the table is larger it takes the formulas that were on the previous days bottom row of imported data, and puts that all the way on the bottom row of the current days table, which is larger than yesterday.
So if yesterday I had 200 rows and today I had 300 rows, row 200 formulas (today) would say A300, row 201 would say A301, and so on. Obviously messing up everything below 200 for the current day.
On today's, one formula would go something like this:
=IFERROR((LEFT(D210,LEN(D210)-11)),0)
=IFERROR((LEFT(D300,LEN(D300)-11)),0)
=IFERROR((LEFT(D301,LEN(D301)-11)),0)
Kind of like the power query is taking todays import and sticking it in between yesterdays bottom two rows.
I hope any of that makes sense.
If anyone knows how I can correct this I would greatly appreciate it.
Thanks!
and I have all my formulas to the right of the imported table.
Sometimes the table is larger or smaller (rows-wise) based on however big the table is that day from the website.
So I have my formulas down way past the most rows I know the table would be on any given day.
The problem I am having is that when the table is larger it takes the formulas that were on the previous days bottom row of imported data, and puts that all the way on the bottom row of the current days table, which is larger than yesterday.
So if yesterday I had 200 rows and today I had 300 rows, row 200 formulas (today) would say A300, row 201 would say A301, and so on. Obviously messing up everything below 200 for the current day.
On today's, one formula would go something like this:
=IFERROR((LEFT(D210,LEN(D210)-11)),0)
=IFERROR((LEFT(D300,LEN(D300)-11)),0)
=IFERROR((LEFT(D301,LEN(D301)-11)),0)
Kind of like the power query is taking todays import and sticking it in between yesterdays bottom two rows.
I hope any of that makes sense.
If anyone knows how I can correct this I would greatly appreciate it.
Thanks!