Returning row numbers of a specific number that occurs multiple times in a column

**Timicheckmate** · 03-30-2019, 10:42 AM

Good Day All.

Example

A B
1 2 1
2 1 3
3 2 4
4 2 9
5 6
6 4
7 5
8 9
9 2

In the example above, 2 appears in cells A1,A3,A4 and A9. I need a formular that will return in column B the row numbers in which 2 appears in column A. Thank you.

**Fluff13** · 03-30-2019, 11:11 AM

How about

Formula:

Please Login or Register  to view this content.

Returning row numbers of a specific number that occurs multiple times in a column

LinkBack

Thread Tools

Rate This Thread

Display

Returning row numbers of a specific number that occurs multiple times in a column

Re: Returning row numbers of a specific number that occurs multiple times in a column

Thread Information

Users Browsing this Thread

Similar Threads

displaying number of times a word occurs in a table column with VBA

[SOLVED] Finding the number of times a specific numerical day occurs

[SOLVED] How to sum the number of times a value occurs in a column?

[SOLVED] Returning a number of how many times a record occurs in an array, based on a related value

Counting the number of times a specific name occurs between a specified period of time

[SOLVED] counting number of times a year occurs in a column range

Counting Number of Times a Numerical Response Occurs in Column

Bookmarks

Bookmarks

Posting Permissions