LinkBack URL
About LinkBacks
I'd use INDEX instead:
=SUMPRODUCT(1/COUNTIF('Sheet1 '!B1:INDEX('Sheet1 '!B:B,A1),'Sheet1 '!B1:INDEX('Sheet1 '!B:B,A1)))
You could shorten with LET
I'd use INDEX instead:
=SUMPRODUCT(1/COUNTIF('Sheet1 '!B1:INDEX('Sheet1 '!B:B,A1),'Sheet1 '!B1:INDEX('Sheet1 '!B:B,A1)))
You could shorten with LET
Everyone who confuses correlation and causation ends up dead.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks