How do I find last entry for this

Help
1

Untitled
Untitled1273×427 119 KB

I need to know how to dynamically find value(1) under sep-18 so when I add in oct-18/nov-18,
it’ll find the value below it.

Any suggestions?

2

I’m not quite sure I understand what you’re trying to do. It sounds like you want to find the row that has the value 1 under the sep-18 column.

The easiest was to do this is to read in the excel with a read range and then go through the rows with a for each row activity. As for which part you want to be variable you can refer to the column by a String so that is an easy variable. I made a little example of how to check for a variable column and value here.

Sequence.xaml (8.7 KB)