•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Formula needed comparing a specific match of two data fields.
Our take
To determine if the last character of two data fields in Excel are the same, you can use a simple formula. This formula compares the final characters of cells A1 and B1, providing a clear TRUE or FALSE output based on the comparison. By utilizing the RIGHT function to extract the last character from each cell, you can easily set up this check. This approach streamlines your data analysis, ensuring you can quickly verify matches without getting bogged down in complexity.
I need a formula that shows that A1 = B1. Basically I need a check that if the last character of A1 is the same as the last character of B1, then it will output TRUE. Thanks so much.
[link] [comments]
Read on the original site
Open the publisher's page for the full experience