Identify same values in Column A
Closed
Dali
-
Feb 5, 2015 at 02:43 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Feb 9, 2015 at 01:19 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Feb 9, 2015 at 01:19 AM
Related:
- Identify same values in Column A
- The system could not identify your location viber - Guide
- How to delete a column in word - Guide
- Identify power supply connectors - Guide
- Based on the values in cells b77 ✓ - Excel Forum
- Facebook com login identify ctx recover - Facebook Forum
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Feb 9, 2015 at 01:19 AM
Feb 9, 2015 at 01:19 AM
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
