Hello,
Just want to check if there is another way of writing the below formula
It actually works, however, the downside of the formula is that I need to manually select/adjust the Column F if there are more than 27 lines.
=OFFSET(Source!$F$1,1,0,COUNTA(Source!$F$2:$F$27),1)
Perhaps
?Formula:
=OFFSET(Source!$F$1,1,0,COUNTA(Source!F:F)-1,1)
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Working Thanks!Originally Posted by MarvinP
Perhaps
?Formula:=OFFSET(Source!$F$1,1,0,COUNTA(Source!F:F)-1,1)
any sample for us?
Last edited by seercoven; 11-21-2022 at 01:42 AM.
Hey seercoven,
First read about the Offset Function in Excel at:
https://www.onlinepclearning.com/exc...-named-ranges/
Then look at the attached Sample for you.
DNR Offset CountA Example.xlsm
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks