Prev: Formula to add up numbers but there are negatives
Next: Tabbing between text boxes in Excel 2007
From: dlw on 11 Mar 2010 17:20
yes, to get it to display like that, it would be text, in that case, use
=right(a1,5)="25.00" I think you pretty much need a helper col for this kind
of thing.

"Ole" wrote:

> Thanks. That works great.
>
> Taking it to the next level...if my column is 200+98.00, 200+99.00,
> 201+00.00 etc. (I'm guessing these would be considered text, not number cells
> because of the + symbol?) What kind of formula would alow me to filter for
> all ending in 25.00 increment? (eg. 200+50.00, 200+75.00, 201+00.00,
> 201+25.00...)
>
> "Per Jessen" wrote:
>
> > Hi
> >
> > In an helper column insert this formula and copy it down:
> >
> > =MOD(A1,10)
> >
> > Now you can filter for '0' in the helper column.
> >
> > Regards,
> > Per
> >
> > "Ole" <Ole(a)discussions.microsoft.com> skrev i meddelelsen
> > news:5D25A580-C645-44CB-835F-39AB92FF4422(a)microsoft.com...
> > > I have a list of numbers (20000 to 27583)
> > >
> > > I only want to see the info for the rows where the number ends with 0 (eg.
> > > 20000, 20010, 20020 etc. basically every 10th row)
> > >
> > > When I custom filter for "ends with" 0, my whole list goes away.
> >
> > .
> >
First  |  Prev  | 
Pages: 1 2
Prev: Formula to add up numbers but there are negatives
Next: Tabbing between text boxes in Excel 2007