To check first letters of two columns are equal
Closed
donaustin
Posts
3
Registration date
Monday 8 December 2014
Status
Member
Last seen
9 December 2014
-
9 Dec 2014 à 12:08
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 11 Dec 2014 à 11:30
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 11 Dec 2014 à 11:30
Related:
- To check first letters of two columns are equal
- Letters on keyboard not working - Guide
- How to check radiation of mobile - Guide
- How to check liked videos on x - Guide
- Check soft - Download - Finance
- Tmobile data check - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday 12 September 2010
Status
Contributor
Last seen
27 December 2022
555
11 Dec 2014 à 11:30
11 Dec 2014 à 11:30
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
