Hi all,
I have an excell speadsheet with data from people visiting every year. I want to make a list showing in which years they came without putting an "x" to every cell manually.
Which formular do I have to use that the X goes automatically to the cell.
Screenshot_1.jpg
example:
Cell C2-5 quotes 2018, C6 quotes 2016. In cell D2-5 should appear "x", cell D6 ect. should stay blank.
Thanks for your help
Bookmarks