Sep 20 2022 01:06 AM
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 states whether a certain value x in row 1 occurs on the other sheet. Output = 1 if true and =0 if false. What is the easiest way to do this?
Thanks!
Sep 20 2022 01:22 AM
Sep 20 2022 01:54 AM
=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.