i need a formula to get Column D as shown below based on column B (Region Left) & C (Region Right). Both columns are string types. If data is there in both column, it will be same
Sample of the data
Record Region Left Region Right Required new column
1 East East
2 West West
3 North North North
4 South South South
Solved! Go to Solution.
please try:
max([region left],[region right])
cheers,
mark
Hi @AlterMini
Another way of doing it
IIF(!IsEmpty([Region Left]), [Region Left], [Region Right])
Workflow:
Hope this helps : )
Thanks MarqueeCreq, Hammed and Atcodedog05
Suggestions from Marquee and Atcodedog05 works well. Still Region right is missing in Hameed formula.