How to find the nth occurence of a value in a list?

[Anonymous]

Hi,

I know how to find the position of a value in a list by using =List.PositionOf(Table1[ColumnName],[value1]). This wil return the position of the value in the list. But how do i find the posisition of the value in the list for the second or third occurence in the list?

Thanks in advance!

[HotChilli · Accepted solution]

List.PositionOf  can take an optional parameter for the max number of positions to find so put something in there (like 50) and that will return a list of the positions.

You can refer to that list by name with curly brackets with the index of the number inside:

e.g. theList{1}  will return the position of the 2nd occurrence