Forum Discussion
Create a column by comparing two columns in a merged table
hi,
not sure i'm getting your question right but if you need to get what's in the New Column here's the formula"
= if [C2PC Status] = [MSX Status] then "In Sync" else "Out of Sync"
hope this helps,
radpir
hi,
not sure i'm getting your question right but if you need to get what's in the New Column here's the formula"
= if [C2PC Status] = [MSX Status] then "In Sync" else "Out of Sync"
hope this helps,
radpir
Just what i needed Thanks a ton Radpir!
Regards,
Rohith
Hey Radpir, Suppose if you want a more complex scenario where you have to compare two columns of your active workbook with two columns residing in many Excel files in a folder having the same structure, how would you pull the data then. I believe an "AND" operator would do the trick but I have not been able to figure it out so far. By the way, I am using Excel 2016 Power Query. I also believe that since Power Query and BI have many similarities, my question can be answered here.
Hey Radpir, Suppose if you want a more complex scenario where you have to compare two columns of your active workbook with two columns residing in many Excel files in a folder having the same structure, how would you pull the data then. I believe an "AND" operator would do the trick but I have not been able to figure it out so far. By the way, I am using Excel 2016 Power Query. I also believe that since Power Query and BI have many similarities, my question can be answered here.
