LinkBack URL
About LinkBacks
count how many "projector" = 5
=SUM(LEN(A1:A3)-LEN(SUBSTITUTE(A1:A3,"projector","")))/LEN("projector")
sorry
array formula
ctrl + shift + enter
not enter only.
count how many "projector" = 5
=SUM(LEN(A1:A3)-LEN(SUBSTITUTE(A1:A3,"projector","")))/LEN("projector")
sorry
array formula
ctrl + shift + enter
not enter only.
Last edited by vlady; 02-19-2012 at 09:54 PM. Reason: sorry array formula
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
AWESOME!!
I was scratching my head for a while until you added the array part
Is there a way that you can make 'projector' a reference to another cell so that i can copy the formula without having to write it over and over?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks