To check first letters of two columns are equal
Closed
donaustin
Posts
3
Registration date
Monday December 8, 2014
Status
Member
Last seen
December 9, 2014
-
Dec 9, 2014 at 12:08 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Dec 11, 2014 at 11:30 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Dec 11, 2014 at 11:30 AM
Hello,
could you please tell me how to check whether first letters of two columns are equal
could you please tell me how to check whether first letters of two columns are equal
Related:
- To check first letters of two columns are equal
- Keyboard won't type letters - Guide
- Check soft - Download - Finance
- Display two columns in data validation list but return only one - Guide
- Speaker check code - Guide
- How to check bios version - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Dec 11, 2014 at 11:30 AM
Dec 11, 2014 at 11:30 AM
Hi Donaustin,
Sure, but again it would depend on if the comparing data is in the same row.
If it is then try:
=IF(LEFT(A2,1)=LEFT(B2,1),TRUE,FALSE)
Best regards,
Trowa
Sure, but again it would depend on if the comparing data is in the same row.
If it is then try:
=IF(LEFT(A2,1)=LEFT(B2,1),TRUE,FALSE)
Best regards,
Trowa
