min(collect()) but not the first one

Mike matthys

Hello,

Code below checks first in line when there multiple identical fields in LevNaam

Created2 = autonumbering (incrementing numbers but not following up on eachother so i cant use +1)

=IF([Created2]@row = MIN(COLLECT([Created2]:[Created2]; Levnaam:Levnaam; Levnaam@row)); 1;0)

shows created2 "1" as checked

is there a way to check second , third , ... in line

so for example if i want to highlight the 236 created2

created2 levnaam

1 abc

125 abc

236 abc

338 abc

i tried this but only works with follow up numbers so its useless :D

=IF([Created2]@row = MIN(COLLECT([Created2]:[Created2]; Levnaam:Levnaam; Levnaam@row)); 1; IF([Created2]@row = MIN(COLLECT([Created2]:[Created2]; Levnaam:Levnaam; Levnaam@row)) + 1; 2; IF([Created2]@row = MIN(COLLECT([Created2]:[Created2]; Levnaam:Levnaam; Levnaam@row)) + 2; 3; IF([Created2]@row = MIN(COLLECT([Created2]:[Created2]; Levnaam:Levnaam; Levnaam@row)) + 3; 4; IF([Created2]@row = MIN(COLLECT([Created2]:[Created2]; Levnaam:Levnaam; Levnaam@row)) + 4; 5; IF([Created2]@row = MIN(COLLECT([Created2]:[Created2]; Levnaam:Levnaam; Levnaam@row)) + 5; 6; IF([Created2]@row = MIN(COLLECT([Created2]:[Created2]; Levnaam:Levnaam; Levnaam@row)) + 6; 7; IF([Created2]@row = MIN(COLLECT([Created2]:[Created2]; Levnaam:Levnaam; Levnaam@row)) + 7; 8; 0))))))))

hope its possible or maybe possible with a workaround, love to hear it

Paul Newcome

Are you able to post some screenshots for reference? Right off it sounds like you are going to want to look into the SMALL function, but I am not 100% sure without being able to see exactly what you are working with.

Mike matthys

Thx Paul,

i fixed it with another solution :)