Insert First Value from the range

[asolopreneur]

I want a formula which can scan a range and insert first value (number).

	Value	Value	Value	Value
Formula to insert 1 here	1
Formula to insert 2 here		2
Formula to insert 3 here			3
Formula to insert 4 here				4

<tbody>
</tbody>

I don't want to insert all the data manually. I want to insert the data in column "A" whenever I add value from column B to Z.

In A2 the formula should scan B2:Z2 and insert the first value it founds.

P.S - I am using Google sheets.

Thanks

 

[Legacy 143009]

It's simpler than you expect

A2 {=B2:Z2}
A3 {=B3:Z3}
.
.
.


It's an array formula so you have to Ctrl+Shift+Enter after paste

 

[wideboydixon]

In Google Sheets formula for A2 is:

=ArrayFormula(INDEX($B2:$Z2,MATCH(FALSE,ISBLANK($B2:$Z2),0)))

WBD

 

[Legacy 143009]

It's simpler than you expect

A2 {=B2:Z2}
A3 {=B3:Z3}
.
.
.


It's an array formula so you have to Ctrl+Shift+Enter after paste

Ahh sorry. I didn't see you've mentioned Google Sheets

 

[asolopreneur]

Not working.

 

[wideboydixon]

Works for me.

https://imgur.com/a/wwtxJ

WBD

 

[asolopreneur]

Unfortunately I've circular dependency.

 

[wideboydixon]

Can you screenshot the problem? There's no circular dependency in the formula I posted.

WBD

 

[asolopreneur]

Can you screenshot the problem? There's no circular dependency in the formula I posted.

WBD

It's working thanks a lot.