I want to Read Last used Cell value from Column A. Actually My purpose it to increment the Serial Number .
Below ia the screenshot for requirement where 3742 need to read and just below that need to Insert the next serial number 3743.
Variable:
ColToCheck = ColIndex Or ColName
Statement:
dtData.AsEnumerable.ToList.FindLastIndex(Function (x) Not (isNothing(x(ColToCheck)) OrElse String.IsNullOrEmpty(x(ColToCheck).toString.Trim)))
find starter help here:
Get_LastValueIndex_1Col.xaml (6.6 KB)
Check the workflow as specified in link
How to increase Counter dynamically - #6 by NIVED_NAMBIAR
This is the same type usecase
Hope it helps you
Regards
Nived N
Happy Automation
Hello,
Thnx for reply, I have already tried this post and it gives me Blank output. I want to get the value from last updated cell referece.
@nilesh.mahajan - Strange…I just tried the same code and it worked…
Input
Code:
Output: Last cell value
I tried inserting blank rows in between…still the code found the last cell value…here is the proof…
Input
Output:
You are most welcome to try the solution from @ppr & @NIVED_NAMBIAR …
Its done now, thnx for sharing, there was my mistake to provide range details.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.