Forum Discussion
How To? If # in column then populate in other cell
Hello, I am looking for some help automating an entry process. I have attached a photo of what I would like to have accomplished. In my spreadsheet I have several rows of numbers in Column A....
Hi,
You can do that by using this formula:
=IF(ISNUMBER(SEARCH($A2,B$1)),1,0)
Hope that helps
Much appreciated.