LinkBack URL
About LinkBacks
Sine you have 'space' in between items, better to use PROPER.
=SUM(IFERROR((LEN(A$1:A$4)-LEN(SUBSTITUTE(PROPER(A$1:A$4),PROPER(A6),"",TRANSPOSE(ROW(INDEX(A:A,1):INDEX(A:A,MAX(LEN(A$1:A$4))))))))/LEN(A6)*B$1:B$4,0))
Sine you have 'space' in between items, better to use PROPER.
=SUM(IFERROR((LEN(A$1:A$4)-LEN(SUBSTITUTE(PROPER(A$1:A$4),PROPER(A6),"",TRANSPOSE(ROW(INDEX(A:A,1):INDEX(A:A,MAX(LEN(A$1:A$4))))))))/LEN(A6)*B$1:B$4,0))
Regards,
Haseeb Avarakkan
__________________________________
"Feedback is the breakfast of champions"
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks