Aug 28 2020 02:19 AM
I need to set in a maximum count of arguments in my excel sheet
eg: when there are already 3 arguments in a row that you can't set a 4th argument in this row.
Aug 28 2020 11:22 AM
you can use data validation
for example select the 1st row, then go to data validation, select custom
and write
=counta(1:1)<=3
then save.. this way it will only allow three cells to be modified, otherwise it will not accept the input