Hi,
I have made some complicated formula,
How I can scroll formula to bottom means to last row?
Formula:Please Login or Register to view this content.
Hi,
I have made some complicated formula,
How I can scroll formula to bottom means to last row?
Formula:Please Login or Register to view this content.
Last edited by rr1050; 01-07-2021 at 06:07 PM.
Hello,
Not sure to understand your question ...
If you are looking for a formula to get the Address of Last Used Row in Column A :
=ADDRESS(SUMPRODUCT(MAX((ROW(A1:A999))*(A1:A999<>""))),1,4)
No I am not looking for last row, here I am looking for to scroll given formula till bottom.
If you see below I need above formula adjusted to fit below = ""
Please Login or Register to view this content.
We might be in a better position to help if we could see a representative sample of the spreadsheet.
Instructions for uploading an .xlsx file are given in the banner at the top of the page.
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks