Shaun Wingrin
asked on
Excell selection
Say,
I've a column such as below:
6234368
7234598
8344845
I wish to
1. high lite each 4 in position 4 from the left.
2. delete each row with a 4 in position 4.
Using Excel 2013 sheet
I've a column such as below:
6234368
7234598
8344845
I wish to
1. high lite each 4 in position 4 from the left.
2. delete each row with a 4 in position 4.
Using Excel 2013 sheet
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Tx but how can I
1. highlite each 4 in position 4 from the left. or simpler to highlite each row that has a 4 in position 4
1. highlite each 4 in position 4 from the left. or simpler to highlite each row that has a 4 in position 4
ASKER CERTIFIED 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.
=IF(MID(A3,4,1)="4","Delet
Copy down as required then apply filter to this column and select "Delete" entries. You can then highlight all and delete rows, only those visible will be deleted. Remove filter and other values will stay.
Thanks
Rob H