finding the Row number for duplicate entries in a column of data

[WRJPugh]

I have a data sheet with many entries. In column "E" I have the station name entered. In other columns I have a timestamp, username, and dollars and tickets they are issued (we are selling tickets).

I want my user, on a separate sheet, to be able to select a station name and have a report built that reports all the transactions for that station.

I can make all this happen with the indirect function for each column I want to look up, but getting the row number for each instance of the station name is tripping me up. I can get the first one with the function:

=MATCH(V12,DATA!E1:E1001,0)

it returns row 15 in my test case. But, how do I get the next formula (1 row down in the report sheet) to start at row E15 and search to E1001? Every attempt I have made at building a relative reference has returned an error. Many thanks

 

[WRJPugh]

Fixed it, I was merely messing up the syntax. Should have kept working at it.

=match(v12,INDIRECT("DATA!E"&X12+1&":E1001"),0) and it works. X12 being the row number of the previous value.