maximum count arguments

%3CLINGO-SUB%20id%3D%22lingo-sub-1618157%22%20slang%3D%22en-US%22%3Emaximum%20count%20arguments%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1618157%22%20slang%3D%22en-US%22%3E%3CP%3EI%20need%20to%20set%20in%20a%20maximum%20count%20of%20arguments%20in%20my%20excel%20sheet%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eeg%3A%20when%20there%20are%20already%203%20arguments%20in%20a%20row%20that%20you%20can't%20set%20a%204th%20argument%20in%20this%20row.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1618157%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1619855%22%20slang%3D%22en-US%22%3ERe%3A%20maximum%20count%20arguments%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1619855%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F774361%22%20target%3D%22_blank%22%3E%40Jeroendedekker%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eyou%20can%20use%20data%20validation%26nbsp%3B%3C%2FP%3E%3CP%3Efor%20example%20select%20the%201st%20row%2C%20then%20go%20to%20data%20validation%2C%20select%20custom%3C%2FP%3E%3CP%3Eand%20write%3C%2FP%3E%3CP%3E%3Dcounta(1%3A1)%26lt%3B%3D3%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethen%20save..%20this%20way%20it%20will%20only%20allow%20three%20cells%20to%20be%20modified%2C%20otherwise%20it%20will%20not%20accept%20the%20input%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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.

1 Reply

@Jeroendedekker 

 

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