Step Through a filtered list

[Doc2r]

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?

[JBeaucaire]

Click GO ADVANCED and use the paperclip icon to post up a copy of your workbook. Make sure the workbook demonstrates your desired results based on this sample data, show us what you're trying to achieve, basically. Use BEFORE/AFTER sheets if that helps make it clearer.