Create Or Condition for Excel Column

[NISHITHA]

Hello Team,

We have below Excel file with Column Values

Example RoleList Column contains these values as below

RoleList
Chief Marketing Officer (CMO)
Vice President of Marketing
Marketing Strategy Manager
Market Research Analyst
Brand Manager
Brand Specialist
…

Is these a way to create OR Condition directly using Excel

OR condition currently defined as below

ExtractDataCheck = ExtractData.Contains(“Chief Marketing Officer (CMO)”) OR ExtractData.Contains(“Vice President of Marketing”) OR ExtractData.Contains(“Marketing Strategy Manager”) OR ExtractData.Contains(“Market Research Analyst”) …

Is there a way to directly use excel file to define OR Condition

Attached file for Reference
Data_BasedCondition.xlsx (5.0 KB)

Thanks team in advance

[Kismet_Tosun (Kısmet Tosun)]

Hi @NISHITHA

You can use Filter data table activite

[NISHITHA]

Hii @Kismet_Tosun ,

Thanks for sharing

I wanted to understand is there a way to add data directly in Value field( Chief Marketing Officer (CMO),etc) by fetching from that Excel column without typing for each of them one by one

[Kismet_Tosun (Kısmet Tosun)]

Dear @NISHITHA

I think you can not solved without writing. There may be a lot of data.

[chethan.dinnupati (Chethan Kumar DS)]

HI @NISHITHA

To perform operations directly in Excel application for the specified workbook file Data_BasedCondition.xlsx.
We need to write the VBA code to perform the required operations.

Thanks,
Chethan