Forum Discussion
check for data
an easy question, but beyond my simple Excel knowledge: I have a spreadsheet with 26 rows and about 150 columns of text content. I would like to create an overview in a second spreadsheet, which sta...
=COUNT(SEARCH(A1,sheet1!$A$1:$C$3))An alternative could be this formula. Enter the formula with ctrl+shift+enter if you don't work with Office365 or 2021. The range of the formula can be adapted as required.