Reverse Formula

[Rubber Beaked Woodpecker]

Hi guys

I use the following formula to return the last populated cell in row 2.

=IFERROR(@INDEX(2:2,AGGREGATE(14,6,COLUMN(2:2)/(2:2<>""),COLUMNS(A$2:$A$2))),"")

Is there a way I the formula could be modified so that it returns the first populated cell in row 2?

Many thanks

RBW

 

[Skybluekid]

Change 14 to 15. This will change the aggregation from Large to Small, so that should give you the first populated cell.

 

[Rubber Beaked Woodpecker]

Change 14 to 15. This will change the aggregation from Large to Small, so that should give you the first populated cell.

Brilliant thank you

 

[Skybluekid]

Brilliant thank you

No problem

 

[Peter_SSs]

Hi guys

I use the following formula to return the last populated cell in row 2.

=IFERROR(@INDEX(2:2,AGGREGATE(14,6,COLUMN(2:2)/(2:2<>""),COLUMNS(A$2:$A$2))),"")

Is there a way I the formula could be modified so that it returns the first populated cell in row 2?

Many thanks

RBW

Isn't this the same or a continuation of this question?
.. and doesn't it have the same issue regarding inserted columns and copying/dragging the formula?
Please note #12 of the Forum Rules