T
TA
How do I Filter for the last character of a label in Excel 2003. I want to
find every entry that ends in a specific letter.
Thanks
find every entry that ends in a specific letter.
Thanks
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Dave F
If the last character (reading left to right) on which you want to filter is
X, then: =IF(RIGHT(F23,1)="X",1,"") and fill down (correct cell reference as
appropriate).
Then filter the table for all rows which have a 1 value in this helper column.
X, then: =IF(RIGHT(F23,1)="X",1,"") and fill down (correct cell reference as
appropriate).
Then filter the table for all rows which have a 1 value in this helper column.
P
Paul B
Ta, use a helper column, put in =RIGHT(A2,1) and fill down, change to your
data reference and filter on that column
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
data reference and filter on that column
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
P
Peo Sjoblom
TA said:How do I Filter for the last character of a label in Excel 2003. I want to
find every entry that ends in a specific letter.
Thanks
In autofilter use custom and ends with then put the specific letter in
the box
Regards,
Peo Sjoblom