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

Status
Not open for further replies.

Urrme

New Member
Joined
Jun 9, 2014
Messages
20
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


 

Some videos you may like

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.

FryGirl

Well-known Member
Joined
Nov 11, 2008
Messages
1,159
Office Version
2016
Platform
Windows
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.
 

Macropod

Retired Moderator
Joined
Aug 27, 2007
Messages
3,439
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.
 
Status
Not open for further replies.

Watch MrExcel Video

Forum statistics

Threads
1,099,780
Messages
5,470,723
Members
406,719
Latest member
ensbana

This Week's Hot Topics

Top