Days Contained Data in Column

Hi, I have two columns of data that contain the days of the week a flight is operational.

Each column is for a certain flight that operates on those stated days.

The outcome I want to achieve is to know if the days that are contained in the "Right_Operating Days" are within the "Operating Days" column.. it does need to be an exact match, but there do need to be matches. Example attached.

Operating Days.xlsx

Data Investigation

Accepted answers

AngelosPachis

Hi @sevans ,

I have created a workflow that answers your question. I have also added two additional columns that will tell you which of your days matched and which didn't, I thought that would be helpful to know.

Screenshot 2020-11-06 182911.jpg

Please let me know if that worked for you, by the results I got it seems to be working fine.

Regards,

Angelos

example.yxzp

All comments

AngelosPachis

Hi @sevans ,

I have created a workflow that answers your question. I have also added two additional columns that will tell you which of your days matched and which didn't, I thought that would be helpful to know.

Screenshot 2020-11-06 182911.jpg

Please let me know if that worked for you, by the results I got it seems to be working fine.

Regards,

Angelos

example.yxzp

echuong1

You can use a text to columns to split the concatenated values apart. From there, you can use a contains() formula to create a flag for if the value is contained in the other list.

New Workflow5.yxmd

sevans

@ AngelosPachis

Thank you very much for this workflow, this does exactly what I wanted.

The additional clarification to confirm what days are and are not included is also very useful!

Many thanks

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703