What is the best way to select a row with a certain value form a column in Excel?

What is the best way to select a row with a certain value form a column in Excel?
A . Use a Read Range activity to retrieve the contents of the Excel file, and then use a For Each activity loop to iterate through the data and identify the element
B . Use the Find functionality from Excel
C . Use a Read Range Activity to retrieve the contents of the Excel file ,and then use a Select method to identify the desired row

View Answer

Answer: A