Last value in row cell
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.
Comments
-
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
Mathieu | Workflow Consultant
info@evolytion.com
-
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.
-
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.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 221 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 62 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!