MicrosoftHenn Sarv Thanks a Lot Sir !
In actual scenario, Column A is a dynamic named range "ChlDBPer"
To avoid the helper column, I used the following and it seems to be working.
=COUNTIF(OFFSET(A5,0,0,SEQUENCE(ROWS(ChlDBPer)),1),INDEX(ChlDBPer,ROWS(ChlDBPer),1))
Kindly advise if the same is incorrect or inefficient or there is a better alternative.
For the time being, it does not seem to create any speed issues.
Wyn Hopkins I understand Sir ! At present there are additional 9 columns containing some lenghty formulas, which I am trying to tackle. Ultimately I intend to change the same to a table. But in the meantime, thought it would be better to learn some tricks from the experts ! I am always amazed at what people are doing here ! Puts me in the right place, Always !
Thanks a Lot !
