Hi, I am using range names in Formula Option but looking at data currently in a Power Pivot Table. Whilst i can use the first Cell in a column and set the last point well past the last bit of data.; eg $A$1:$A$50000 when the data last row is much less (eg 26898).
However i would like it to reference the last cell row number. I can get the cell address (eg using Match = "A"&MATCH(2,1/(PvTFin!A:A<>""),1) to then have the number of the last cell (eg 26898).
I would like to use that last cell number in the Formula Range Name - eg: RgeAcctRange name = $A$1:$A:$A$26898.
So far not able to get it to work and appreciate any advice.
Regards, Kym
Always difficult to help without seeing your file, but perhaps this does what you have in mind:
=PvTFin!A1:INDEX(PvTFin!A:A,MATCH(2,1/(PvTFin!A:A<>""),1))
Hi Riny, Thank you, I will try this tonight. As yet I have not set up the file properly.
Hi Kym Crettenden!
Did you find a solution yet? I'm a newbie and I'd love to know how you fixed this! I hope you will share it
