How to Find Matching Numbers between two Columns

[#1]

Hi,

Please assist i need to match Cell Numbers between two Columns, but the problem is

one column starts with country code 27

e.g

Column A

0738257934

the other one is

Column B

27738257934

how do i match the two in Set Analysis?

Thanks.

[jagan]

Hi,

Try like this

Sum(Aggr(If(Text(ColumnA)= '0' & Mid(ColumnB, 2), Sum(Sales)), ColumnA, ColumnB))

Hope this helps you.

Regards,

Jagan.

[buzzy996]

if it's front end u can use this directly.

=If(ColumnA='0'& right(ColumnB,9),'Matched','UnMatched')

if it's back end u can use this,

If(ColumnA='0'& right(ColumnB,9),'Matched','UnMatched') as Flag

else ur looking u want to see this only with set expressions?any reason.

[#4]

HI,

it works but how do i exclude Matched from the Field as i uised a List to create a new Column

Regards.

[buzzy996]

okie,wht u want to show on new column?

tht new column want to create when both are matched?

u can just replace what u want to see when it's matched,on the above expression..u can place any text!