LinkBack URL
About LinkBacks
This won't spill. If I understand correctly try this in D2 and double click the fill handle to copy all the way down.Formula:
=LOOKUP(YEAR(B2),{1995,2003},{1;1})*INDEX(FREQUENCY(C2,3-1/10^7),2)
Even over 50,000 + rows this should be lightning fast.
This won't spill. If I understand correctly try this in D2 and double click the fill handle to copy all the way down.Formula:=LOOKUP(YEAR(B2),{1995,2003},{1;1})*INDEX(FREQUENCY(C2,3-1/10^7),2)
Even over 50,000 + rows this should be lightning fast.
Last edited by FlameRetired; 07-14-2022 at 03:56 PM.
Dave
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks