FINDING MULTI-NUMBER SEQUENCES, identifying the rows they occur in, LISTING THEM

[Urrme]

Hi, I'm currently using =COUNTIFS(A1:A1000000,11,A2:A1000001,21,A3:A1000002,31) but I want to modify it to not only count the number of occurrences of 11,21,31 in column A, but to also list them by row.


For example,,,
.........A
25.....11
26.....21
27.....31

.
.
.
15000 11
15001 21
15002 31

I want the formula to display that it occurs twice, and say that it happens in row 25, and row 15000.


Thanks