Forum Discussion
how to count after max digits?
i have excel that counting water indicator, what is the formulas to make 001-999 is counted 2 not -998? (assume max digits is three)
If you have access to TEXTSPLIT, it's straightforward. Presuming the data is in A1, for example:
=COUNTA(TEXTSPLIT(A1,"-")).