how to return a number for how many times a word is used in excel
I am designing a spreadsheet and cannot figure out the formula to return a
number for how many times a word has been used in a range of cells. Please help. |
SUMPRODUCT(--ISNUMBER(SEARCH("<word to search for",<range)))
-- David Billigmeier "James Houck" wrote: I am designing a spreadsheet and cannot figure out the formula to return a number for how many times a word has been used in a range of cells. Please help. |
All times are GMT +1. The time now is 12:39 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com