Madhuri_G
Member
Hi Chandoo/Brilliant Guys out there..
I just want to know answer for the below scenario... I tried this formula but it's not working. Can you please help me guys..
I have data in 8SEGMENTS with contacts FULLSalutation, for contacts under 18 they should be addressed as Lastname + Familyname.
For records with if name has one initial, or initials, or dots(anomalies) it should change to 'Supporter'
I'm getting error for one initial, or initials, or dots(anomalies)
Can you please rectify this??
=IF(AND(AK5<18,AK5<>""),CONCATENATE(H5," ","Family",""),IF(OR(CD5="SEGMENT_1",CD5="SEGMENT_2",CD5="SEGMENT_3",CD5="SEGMENT_4",CD5="SEGMENT_5",CD5="SEGMENT_6",CD5="SEGMENT_7",CD5="SEGMENT_8"),
IF(BJ5,"Supporter",
IF(OR(I5="",I5=".",I5="Unknown",LEN(TRIM(I5))=1),
E5&" "&H5,
I5)
),
))
I just want to know answer for the below scenario... I tried this formula but it's not working. Can you please help me guys..
I have data in 8SEGMENTS with contacts FULLSalutation, for contacts under 18 they should be addressed as Lastname + Familyname.
For records with if name has one initial, or initials, or dots(anomalies) it should change to 'Supporter'
I'm getting error for one initial, or initials, or dots(anomalies)
Can you please rectify this??
=IF(AND(AK5<18,AK5<>""),CONCATENATE(H5," ","Family",""),IF(OR(CD5="SEGMENT_1",CD5="SEGMENT_2",CD5="SEGMENT_3",CD5="SEGMENT_4",CD5="SEGMENT_5",CD5="SEGMENT_6",CD5="SEGMENT_7",CD5="SEGMENT_8"),
IF(BJ5,"Supporter",
IF(OR(I5="",I5=".",I5="Unknown",LEN(TRIM(I5))=1),
E5&" "&H5,
I5)
),
))