Sign in to join the conversation:
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.
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
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.
As follows
Will it always be numbers and will they always go in ascending order from left to right?
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.
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.
I know I'm going to kick myself when this gets resolved, but I'm having a bit of a brain fart right now. I'm trying to get the lowest non-blank value in a particular range (columns A-E). [A]@row=18, [B]@row=16, [C]@row, [D]@row, & [E]@row are all blank. All five rows are products of column formulas. Basically, there are a…
I am trying to have the Drop Dead column subtract 42 days from the Final Confirmation Date. I have the Drop Dead column setup as a Date Column and have tried doing this formula, but am getting an "Invalid Operation" error. Can anyone tell me what I am doing wrong? And thanks in advance.
I am wanting to have a sheet that is going to have all of our production records on it. The office manager will enter all of the work order information with 1 form, and someone in Quality will enter the measurements on another form. If I have the Primary Column as each part's serial number, will the measurement info be…
