Hi all,

I have a column of staff numbers like so:

30002042
30002026
30002072
30002070
30002094
30002008
30002022
30002018
30002099
30002031
30002062

When I try to find all staff whose number ends in 2, my *2 wildcard criteria 
is retirning no records.  I have tried formatting the range to number, 
general and text to no avail!  Can anyone tell me what I'm missing here?

Many thanks

Andy

Wildcard characters only work with text values. The easiest way I can think 
would be to create a helper column with:
=--RIGHT(A2,1)
copied down, and then have the Advanced Filter search on with a criteria of 
just 2.
-- 
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"ajayb" wrote:

> Hi all,
> 
> I have a column of staff numbers like so:
> 
> 30002042
> 30002026
> 30002072
> 30002070
> 30002094
> 30002008
> 30002022
> 30002018
> 30002099
> 30002031
> 30002062
> 
> When I try to find all staff whose number ends in 2, my *2 wildcard criteria 
> is retirning no records.  I have tried formatting the range to number, 
> general and text to no avail!  Can anyone tell me what I'm missing here?
> 
> Many thanks
> 
> Andy

Excel 2007 PivotTable
No formula or helper needed.
http://www.mediafire.com/file/mmtzbzzmddm/02_11_10a.xlsx

Thanks Luke.  Was hoping for a more straightforward way but at least it does 
the trick!

Regards

Andy

"Luke M" wrote:

> Wildcard characters only work with text values. The easiest way I can think 
> would be to create a helper column with:
> =--RIGHT(A2,1)
> copied down, and then have the Advanced Filter search on with a criteria of 
> just 2.
> -- 
> Best Regards,
> 
> Luke M
> *Remember to click "yes" if this post helped you!*
> 
> 
> "ajayb" wrote:
> 
> > Hi all,
> > 
> > I have a column of staff numbers like so:
> > 
> > 30002042
> > 30002026
> > 30002072
> > 30002070
> > 30002094
> > 30002008
> > 30002022
> > 30002018
> > 30002099
> > 30002031
> > 30002062
> > 
> > When I try to find all staff whose number ends in 2, my *2 wildcard criteria 
> > is retirning no records.  I have tried formatting the range to number, 
> > general and text to no avail!  Can anyone tell me what I'm missing here?
> > 
> > Many thanks
> > 
> > Andy

Hi Herbert,

Unfortunately I'm using 2003, should have said that at the beginning.  
Thanks for your help though.

Regards

Andy

"Herbert Seidenberg" wrote:

> Excel 2007 PivotTable
> No formula or helper needed.
> http://www.mediafire.com/file/mmtzbzzmddm/02_11_10a.xlsx
> .
>