Identify same values in Column A [Closed]

Report
-
venkat1926
Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
-
Hello,
I have an excel sheet with too many rows.
But in Column A, I have many values which starts with XYZ. I have to identify them and need to use a unique value say TRUE or FALSE in Column B. How can I do this?
Thanks
Dali

1 reply

Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
790
if the data is in column A from A1 down in B1 type this formul

=IF(LEFT(A1,3)="xyz",A1,"")

copy B1 down