Forum

Notifications
Clear all

Find the last row of the data and formula to automatically fill down

2 Posts
2 Users
0 Reactions
96 Views
(@back2awake)
Posts: 30
Eminent Member
Topic starter
 

Hi All,

I have formulas in N4 til Z4. The data is obtained via Power Query and can go up to 50,000 rows. I have to fill the formula down manually every time. Is there any way where the formulas check the last row of the data and filled down automatically?

Please see the attached file.  

 
Posted : 20/07/2023 3:09 am
(@debaser)
Posts: 836
Member Moderator
 

It would probably make more sense to do all of this in the original query, but you have removed the queries which makes that a little tricky. 😉

 
Posted : 21/07/2023 3:46 am
Share: