nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Counting...

UberBock

So I have a column like this (it is character) and I would like to create a way to add a countup of the times it occurs. The data will be sorted by another column which is test date/time so that I can later see if the 1st or 2nd or 3rd etc...time in the Aliquot are different than the 4th or 5 etc....so how to count sequentially based on the AliquotID

AliquotID New Column

11172 1
11172 2
11172 3
11172 4
11172 5
11172 6
11173 1
11173 2
11173 3
11173 4
11173 5
11173 6
11174 1
11174 2
11174 3
11174
11174
11174
11175
11175
11175
11175
11175
11175
11176
11176
11176
11176
11176
11176

Accepted answers

txnelson

try this formula

If( Lag( :AliquotID ) != :AliquotID,
	x = 1,
	x = x + 1
);
x;

All comments

Mark_Bailey

Sort by AliquotID and Date. Then run this script:

Current Data Table() << New Column( "Replicate", "Numeric", "Ordinal",
	Formula( If( Row() == 1, 1, :AliquotID == Lag( :AliquotID ), Lag( :Replicate ), Lag( :Replicate ) + 1 )
);

txnelson

try this formula

If( Lag( :AliquotID ) != :AliquotID,
	x = 1,
	x = x + 1
);
x;

Mark_Bailey

This kind of question has been asked and solved before.

UberBock

Thank you so much!