How 2 find position if target value is in both column and row

Help
1

in this scenario have

|Date1|Date2|Date3|Date4|Date5|
|Date2|||||
|Date3||_____|||
|Date4|||____||
|Date5|||____|Target|

how to find target cell???

1 Like
2

Hi @nuttapong_ludloy,
Can you explain little more clearly?

3

I’m open from excel file (sample in picture)image
I want to action in yellow cell.

1 Like
4

–use excel application scope and pass the file path as input
–use a read range activity and get the output with a variable of type datatable named outdt, (make sure that the variable is with the scope of whole sequence in variable panel)
–next to this excel application scope use a write line activity and mention like this
outdt.Rows(outdt.Rows.Count-1)(outdt.Columns.Count-1).ToString
this will give the value of last row and last column i.e., G8 value (Target cell)
we can use this in assign activity as range

Hope this would help you
Kindly try this and let know for any queries or clarification
Cheers @nuttapong_ludloy