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. What I would like is if a function can look at the numbers in Column A, and fill in a 1 into the corresponding cell which matches its number designation, and a 0 if it does not match.
For example: CellA2 = 2, so CellC2 gets filled in with a 1, and everything else with a 0.
Is there an easy way to automate this? Maybe split it up into steps, or multiple functions. Help would be greatly appreciated.