siddharthkool
asked on
Delete selected rows from Excel
I have number of spread sheets and I want to delete records from them.
Example :
I have following data in spreadsheet:
Name Id
GenePoint 001E0000002eoqCIAQ
United Oil & Gas, UK
United Oil & Gas, Singapore
Edge Communications 001E0000002eoqFIAQ
what i want to do is : i want to delete records which don't have ID. i.e United Oil & Gas, UK
United Oil & Gas, Singapore . also i dont want to delete header fields that is Name and id.
how can i do it ??
Example :
I have following data in spreadsheet:
Name Id
GenePoint 001E0000002eoqCIAQ
United Oil & Gas, UK
United Oil & Gas, Singapore
Edge Communications 001E0000002eoqFIAQ
what i want to do is : i want to delete records which don't have ID. i.e United Oil & Gas, UK
United Oil & Gas, Singapore . also i dont want to delete header fields that is Name and id.
how can i do it ??
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
Cheers
Rob H