Forum

Notifications
Clear all

Formula for show latest value of column A to column B

3 Posts
2 Users
0 Reactions
68 Views
(@soubasa)
Posts: 21
Eminent Member
Topic starter
 

Hello,

I need Formula for show latest value of column A to column B

and I explained more in the file

Thank you in advance for your answer

 
Posted : 10/09/2021 7:31 am
(@soubasa)
Posts: 21
Eminent Member
Topic starter
 

Hello again,

In the file in this post I copied column A and B and added new value in each section

Thank you very much for your reply

 
Posted : 10/09/2021 2:00 pm
Anders Sehlstedt
(@sehlsan)
Posts: 974
Prominent Member
 

Hello,

Not sure what you have tried with, but this only need an empty row 1 and then an ordinary IF function to check if A2 is empty, if true then take value from B1, else take value from A2.

Br,
Anders

 
Posted : 10/09/2021 2:27 pm
Share: