Find in Worksheet with OR condition

DipinDevP — Thu, 17 Oct 2024 04:45:02 GMT

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

Re: Find in Worksheet with OR condition

Tejaskumar_Darji — Thu, 17 Oct 2024 05:45:18 GMT

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.

topic Re: Find in Worksheet with OR condition in Product Forum

Find in Worksheet with OR condition

Re: Find in Worksheet with OR condition