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

What is the best way to select a row with a certain value from 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
B . Use a Read Range Activity to retrieve the contents of the Excel file, and then use a
Select Method to identify the desired row
C . Use the Find functionality from Excel

View Answer

Answer: B