Muthukrishnan V
Active Member
- Joined
- May 29, 2008
- Messages
- 280
- Office Version
- 365
- Platform
- Windows
Office 365
Column C5 to C370 are Numerical round numbers.
Based on values from Column B, Column C gets updated chronologically
and yesterday Cell C153 got updated and today Cell C154 got updated.
As of now Column C155 to C370 are blank. Cell C155 gets updated tomorrow based on Cell B155.
I request a formula in Cell J5 to show the latest updated value in Column C.
(In the instant case C5 to C154 are filled; and C155 to C370 are blank)
Cell J5 should show the value of C154, being C154 is the latest entry.
Thanking you,
Column C5 to C370 are Numerical round numbers.
Based on values from Column B, Column C gets updated chronologically
and yesterday Cell C153 got updated and today Cell C154 got updated.
As of now Column C155 to C370 are blank. Cell C155 gets updated tomorrow based on Cell B155.
I request a formula in Cell J5 to show the latest updated value in Column C.
(In the instant case C5 to C154 are filled; and C155 to C370 are blank)
Cell J5 should show the value of C154, being C154 is the latest entry.
Thanking you,