With the given information, i took into consideration that you know the column name or index of the column that has the *** value and the last column with value you want to check with (whether positive or negative.)
with that case, kindly refer to the below xaml and xlsx file for reference, Hope would help you…
Thanks for quick response
i dont no the column name and row name in excel
i have to search the 3 stars *** and scroll to the last figure on the right.and get the value
Try this,
Step 1 :use send hotkeys ctrl+f,search for ZZZ
Step 2 : find the cell then us short cut keys ctrl+rightarrow
Step 3: use send hot key to copy data Ctrl+c
Step 4: get copied data from clipboard
Step 5 :Check negative amount (<0) or Positive amount (>0)
Let’s assume you use Read Range to store the data to a data table (I’ll call dt1)…
You can use .ItemArray to check for “***”, then based on if it contains the 3 stars, pull in the very last item in the row.
Additionally, we can start by filtering to only the rows that have “Yes”.
So, here is some pseudocode that might represent the steps needed:
Read Range
ForEach row in dt1.AsEnumerable.Where(Function(r) r(0).ToString.Trim.ToUpper = "YES").ToArray
If activity: condition: row.ItemArray.Contains("***")
Then
If activity: condition: If(IsNumeric(row.ItemArray.Last), CDbl(row.ItemArray.Last) >= 0, False)
Then <do something for positive value>
Else <do something for negative value>
EDIT: you might also want to do something if the value is not a number.
If row.ItemArray.Contains("***")
the above part checks if the row has 3 stars, so then you can check the last value.
Essentially, you need to loop for each row where the first column has “yes”, check if the row has 3 stars, if so then look at last value in the row.