Feb 17 2022 08:13 AM - edited Feb 17 2022 09:00 AM
Hi all, the title is pretty self-explanatory.
Thank you in advance
Feb 17 2022 11:18 AM
I didn't catch the idea of such data structuring, but the logic of data validation is different for first cells and the rest. In first cells data validation list refers on spill which selects data based on the same cell. Rest of cells has one position shift for spill formula criteria.
Feb 17 2022 11:50 AM