finding a 3 NUMBER SEQUENCE, And displaying which rows it occurs in.

[Urrme]

Hello, I'm trying to find out how to list which rows a number sequence occurs, in Column A, in a simple way, that doesn't make me search through a massive column in a workbook. I just want to see the rows it occurs in, without having to go down to those rows.

The number sequence to find is 11,21,31.
I am using =COUNTIFS(A1:A10000,11,A2:A10001,21,A3:A10002,31) but I want to modify it to show which rows the sequence happens in not just how many times.

I have searched Google, and couldn't find a solution

 

[FryGirl]

Isn't this a duplicate of this thread

 

[Urrme]

Yes. Is that against rules? Does no one know an answer?

 

[FryGirl]

Seems to be...

Rule #12:
Do not post duplicate questions. Posts of a duplicate nature will be deleted or locked. All related follow-ups, be they further related questions or clarifications, should be posted back to the original thread.

We advise you not to 'bump' (reply to) your own posts too quickly after posting, unless you are posting some sort of clarification. Since bumped threads have replies, they will no longer appear in the "Zero Reply Posts" listing, which many members use to look for unanswered questions. If you do bump, limit it to no more than once every day. Remember that your best helper may be asleep on the other side of the world.

 

[Urrme]

So you don't know an answer?

 

[Macropod]

The issue here isn't whether anyone knows an answer. The issue is that it is a duplicate thread in violation of the forum rules. Thread closed.