Im trying to reference a column called "Channel" and have the active cell, which is under the column "Terminal" stay consistent for the amount of points there are in the channel, and then add one number and do the same thing.
So I have a column named "Channel" and this column continues to count from 1-8 and restarts every time another set of a channel is added. Sometimes it can restart after reaching 4, and that is based on some specifics that are irrelevant to the question. So an example would be that the "terminal" column populates like this: 1, 1, 1, 1, 1, 1, 1, 1, 2, 2, 2...
I used an if statement, but it doesnt add 2 and 3 when needed
=IFS(L10>=1,1)
and then i tried this one to add the extra number, but i dont think it recognizes the value of the cell
=IFS(L11>=1,1,L11=1,M10+1)

Aucun commentaire:
Enregistrer un commentaire