Find in Worksheet with OR condition

[DipinDevP]

Hi,

I wanted to check whether few values are there in certain range in an Excel sheet. I think, I can use Find in Worksheet action from MS Excel VBO to achieve it, but is there any way to provide OR condition in Search Text input parameter something like 'abc' OR 'def'? 

Thanks,

Dipin Dev P

Blue Prism Trial Blue Prism Enterprise v7 Blue Prism Cloud 2023.1 

[Tejaskumar_Darji]

Hello,

To efficiently perform complex logical operations, it's advisable to first gather the entire sheet into a collection. This approach is generally faster and offers more features through collection utilities compared to directly manipulating Excel.

If you need to work directly in Excel, consider applying a formula in a new column using multiple conditions, then filter the data accordingly.