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.
Please Login or Register to view this content.
Perhaps
?Formula:
Please Login or Register to view this content.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
any sample for us?
Last edited by seercoven; 11-21-2022 at 01:42 AM.
Working Thanks!Originally Posted by MarvinP
Perhaps
?Formula:Please Login or Register to view this content.
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