Last value in row cell

Ercument YILDIRIM

Hi;

I want to write the last cell in the row to the first cell. There are empty cells in between. Can you help me.

Good work.

Mathieu PERSICO

Hi Ercument,

Not sure to understand correctly your requirement but let suppose you have Column1 to Column5 . If you want to get the value of Column5 into Column1, simply enter this formula in Column1"=[Column5]@row". Tell me if this is what you expected.

Hope this helps!

Have a good day,

Mathieu | info@evolytion.com

Ercument YILDIRIM

Hi;

When data is written to any cell in the row I want to make, I always want to print the data in the last row to the first row.

Have a nice day.

Ercument YILDIRIM

As follows

Paul Newcome

Will it always be numbers and will they always go in ascending order from left to right?

Ercument YILDIRIM

There will not always be a number. There are project numbers, but there are letters in it. It will always go from left to right, but it will be in empty cells in between.

Paul Newcome

Ok. I am going to suggest a "helper row" in my example I will use row 1. In this row you will enter the numbers starting at 1 from left to right across the columns you want to pull from.

Then you could use a formula such as...

=INDEX([First Column]@row:[Last Column]@row, 1, MAX(COLLECT([First Column]$1:[Last Column]$1, [First Column]@row:[Last Column]@row, @cell <> "")))

The screenshot below shows the helper row on row 1 highlighted in green.