Ive seen this topic a few times but nobody seems to have an answer to the following:

I have a filtered list of columns, i need to step through the list performing a test on the value in the 2nd column with all the previous values and based on the outcome create a value in the 6th column. The list is not contiguous. The way i would like to do it is to return the row number of each item in the filtered list.

Anyone any ideas?