I'd like to find the cell address

Help Activities
, ,
1

The image shows an Excel spreadsheet with columns labeled A, B, C, and D, where column D contains repeated text values "UV1," "UV2," "SD1," and "SD2." (Captioned by AI)
The image shows an Excel spreadsheet with columns labeled A, B, C, and D, where column D contains repeated text values "UV1," "UV2," "SD1," and "SD2." (Captioned by AI)337×605 4.08 KB

There is a data table as shown above.

I would like to know the address values of cells with corresponding values such as UV1, UV2, SD1, SD2 in column D.
This is because the number of values changes every time and the address changes.
However, column D does not change.

After executing one of the values in D, I want to write the activity in column A of the same row, but I need an address value, so I need to get that value.
For example, if i am running based on SD1, I should know that SD1 is in lines 14 to 19 of column D
Then I can enter any value from row 14 to row 19 in column A with WRITE CELL ACTIVITY, so I need the address.

So, I would appreciate it if you could let me know if you can get the address value through formulas or activities.

2

@sssim4567

  1. Read the data into datatable dt
  2. Now use filter datatable and filter with required value say uv1 for now…from this you would get the count of rows which have uv1…and I assume all similar values are together
  3. Then use lookup datatable or lookup excel or find/replace activity to find first cell of uv1…
  4. Now combine the first cell and the row count to get the last cell jumber as well…so you hve the eange now

Cheers