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
- Identify signature by photo - Guide
- Identify power supply connectors - Guide
- How to identify cpu physically - Guide
- How to convert row to column in notepad++ ✓ - Excel 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
