How to Read Last used Excel Cell Value from specific Column

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.

image

@nilesh.mahajan - Please check this post…

@nilesh.mahajan

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)

1 Like

Hi @nilesh.mahajan

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 :robot:

Happy Automation :relaxed::relaxed::relaxed::relaxed::relaxed:

1 Like

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
image

Code:

image

Output: Last cell value

image

I tried inserting blank rows in between…still the code found the last cell value…here is the proof…

Input

image

Output:
image

You are most welcome to try the solution from @ppr & @NIVED_NAMBIAR

1 Like

:grinning: Its done now, thnx for sharing, there was my mistake to provide range details.

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.