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
Hello,

could you please tell me how to check whether first letters of two columns are equal

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
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
0