Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi,
Try like this
Sum(Aggr(If(Text(ColumnA)= '0' & Mid(ColumnB, 2), Sum(Sales)), ColumnA, ColumnB))
Hope this helps you.
Regards,
Jagan.
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.
HI,
it works but how do i exclude Matched from the Field as i uised a List to create a new Column
Regards.
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!