Identify same values in Column A
Closed
Dali
-
5 Feb 2015 à 14:43
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 9 Feb 2015 à 01:19
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 9 Feb 2015 à 01:19
Related:
- Identify same values in Column A
- How to delete a column in word - Guide
- Excel column number - Guide
- Based on the values in cells b77 - Excel Forum
- The system could not identify your location viber - Guide
- Freefacebook.com login/identify - Facebook Forum
1 response
venkat1926
Posts
1863
Registration date
Sunday 14 June 2009
Status
Contributor
Last seen
7 August 2021
811
9 Feb 2015 à 01:19
9 Feb 2015 à 01:19
if the data is in column A from A1 down in B1 type this formul
=IF(LEFT(A1,3)="xyz",A1,"")
copy B1 down
=IF(LEFT(A1,3)="xyz",A1,"")
copy B1 down
