liabilityquek
Member
Hi Guys
I have 5 different email fields; Email 1, 2, 3, 4 and 5
In row 1; I have "field1gmail.com", "field2gmail.com", "field3gmail.com", "field4gmail.com", "field5gmail.com" for Email 1, 2, 3, 4 and 5 respectively.
In row 2; I have "field5gmail.com","field4gmail.com", "field3gmail.com", "field2gmail.com", "field1gmail.com" for Email 1, 2, 3, 4 and 5 respectively.
I use concatenate to merge the 5 emails together.
The purpose is to identify whether is there any changes in email address regardless of the emails being place in different Email fields.
Therefore, it seems that if I were to use cell1(merge emails for row1) = cell2(merge emails for row2); the result become false.
Please advice what formula show I use apart from VBA.
I have 5 different email fields; Email 1, 2, 3, 4 and 5
In row 1; I have "field1gmail.com", "field2gmail.com", "field3gmail.com", "field4gmail.com", "field5gmail.com" for Email 1, 2, 3, 4 and 5 respectively.
In row 2; I have "field5gmail.com","field4gmail.com", "field3gmail.com", "field2gmail.com", "field1gmail.com" for Email 1, 2, 3, 4 and 5 respectively.
I use concatenate to merge the 5 emails together.
The purpose is to identify whether is there any changes in email address regardless of the emails being place in different Email fields.
Therefore, it seems that if I were to use cell1(merge emails for row1) = cell2(merge emails for row2); the result become false.
Please advice what formula show I use apart from VBA.
|
|
|
|
| ||||||
| ||||||||||
| ||||||||||
|