Detecting a special value in a column and retriving alla the relative one in that row


i have an excel sheet and i need to check in 1 column if there is a special character “?” and return the value of the corresponding cell in another column column2 and for the end shows all the values in one other columns

Hi @abdel,

Follow below steps:

  1. Check for the special character in the value retrieved using read range.
  2. If there is a special character use “get row item” to retrieve the corresponding cell and write the same matching corresponding value to next cell.

Provide me the excel you are using for this task.


hello Girish,