FryGirl
Well-known Member
- Joined
- Nov 11, 2008
- Messages
- 1,368
- Office Version
- 365
- 2016
- Platform
- Windows
I've been reading about the Last Numeric Value in a column and understand the concept, but why is
=ROUNDUP(COUNT(G1:INDEX(G:G,MATCH(BigNum,G:G)))*0.2,0)
better than
=ROUNDUP(COUNT(G:G)*0.2,0)
if you know there is nothing underneath the last value? Is it more efficient because of the mere fact it does not look down the entire column?
=ROUNDUP(COUNT(G1:INDEX(G:G,MATCH(BigNum,G:G)))*0.2,0)
better than
=ROUNDUP(COUNT(G:G)*0.2,0)
if you know there is nothing underneath the last value? Is it more efficient because of the mere fact it does not look down the entire column?