Find row number in filter function result-CodePudding

In a filter result I want to search for a date and return the row number (not sheet row, but row in the result)

My idea was to find it with Match, but it is not working. See the picture to understand the problem.

I need this to make a formula to show the difference between the dates of "XY". My approach is filter for XY, get the position of the date minus 1.

CodePudding user response：

Your filter should only return column B:

=MATCH(H3;FILTER(B4:B12;A4:A12="xY");0)

CodePudding user response：

Try below formula-

=MATCH(H3,INDEX(TRANSPOSE(FILTER(A4:B12,A4:A12="XY")),2),0)

CodePudding user response：

Or using the same logic as the filter:

=FILTER(ROW(A4:A12),A4:A12="XY")