sorting a list

[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.

 

[Govind]

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.

 

[Frank Kabel]

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

 

[Lindy51]

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?

 

[Guest]

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



.