Finding the Row Number with the First Paired Set

[SDruley]

I have two columns of numbers:

A B
1
4
2
6
4
5 6
3 3
2 4
4 1

What is an easy way to find the row number that contains the first entry of two numbers. Obviously, the answer is 6 but what is the formula?

[Ron Coderre]

Using your posted data, beginning in cell A1...
This formula returns the row number of the first pair of numeric values:

Please Login or Register  to view this content.

Is that something you can work with?

[zbor]

Or this:

=INDEX(A:A,MIN(IFERROR(MATCH($B$5:$B$8,$A$1:$A$100,0),"")))

(comfirmed with ctrl+shift+enter)

[KiPA]

Or if the data is always like this - unbroken one column rows followed by unbroken two column rows - : =COUNT(A1:A9)-COUNT(B1:B9)+1

[zbor]

Hi KiPA...

Your formula will always return number 6, no matter of inputs... as long as there are all numbers...

[KiPA]

Really? Works for me. Maybe I'm just tired and the whole thing went beyond my brain functions.

Edit: actually I can't get your formula working. All I can get is... something. The value even changes if I delete some number in B column and add it again.

[Ron Coderre]

I'm not sure if this makes a difference to the poster, but the request was for the Row Number...not the position in the list.

Using the formulas I'm seeing posted, their return values coincidentally match the row numbers only if the data begins in Row_1. The formula I posted returns the row number, no matter which row is the start of the data.

[SDruley]

Thanks to everyone who contributed to this query. It is amazing how many different solutions there are for a given situation. All solutions worked.

[zbor]

I'm not sure if this makes a difference to the poster, but the request was for the Row Number...not the position in the list..

Hm, I guess you are right Ron...