sorting a list

  • Thread starter Thread starter lindy51
  • Start date Start date
L

lindy51

I need to be able to either sort by or remove all part
numbers from a column that end in Z. Can you help me
please? Thanks much.
 
Hi,

Use Filter - Autofilter to find all the numbers from that column and
delete those values alone or that row itself, if no other numbers are
present in any other column

Govind.
 
Hi
you may use a helper column with the following formula
=IF(RIGHT(A1,1)="Z",1,0)
copy down for all rows and filter with this column
 
Unfortunately, there are over 26,000 part numbers in my
column, so I'd still be needing to go through the whole
list to identify them. Is there anything else I can do?
 
wonderful! Thank you!
-----Original Message-----
Hi
you may use a helper column with the following formula
=IF(RIGHT(A1,1)="Z",1,0)
copy down for all rows and filter with this column

--
Regards
Frank Kabel
Frankfurt, Germany



.
Click to expand...
 
Back
Top