nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Welcome!

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.

Find more posts tagged with

Comments

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.

Sign in to join the conversation!

Quick Links

Trending discussions

% Complete Column Appears Broken
The screenshot shows an assignment I am working on for an online class. I have a question about the lines highlighted in yellow. The "% Complete" column is supposed to show a calculation of the children's done percentage, I think. Am I understanding that correctly? If so, the Campus & Grounds line (NPI-052) showing 51%…
Copy rows to other sheet as values only?
What are some tips please to copy/move rows to other sheet as values only? Specifically, rows which contain column formulae. Is there a known workaround, or should I just use DataMesh? My main issue with this is that I can't copy columns containing column formulae. Thanks for your help, Matt
Based on Value in Column A, do a lookup to a different sheet
So I have Sheet 1 = List of locations. In it I have various values, ID, Name, Address, City, State, Zip, Country, Phone. Example: ID= 001 Name= Chicago Naperville In Sheet 2 = Incident Reporting. In this sheet, I have a dropdown list that pulls the ID value from Shee1 List of Locations. The sheet has a form where the user…