Prev: Formula to add up numbers but there are negatives
Next: Tabbing between text boxes in Excel 2007
From: Ole on 11 Mar 2010 13:05
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.
From: Per Jessen on 11 Mar 2010 13:16
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.

From: dlw on 11 Mar 2010 13:31
filter on =mod(a1,10)=0

"Ole" wrote:

> 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.
From: Ole on 11 Mar 2010 13:51
Thanks, that seems to work. I don't have a whole lot of time filtering and
stuff with excel 07. Used to the old version of excel.

Is there a way to filter this without making a "helper column? I have other
spread sheets where column a has info like:

10+00.00
10+05.00
10+10.00
10+15.00
10+20.00...

I used to be in previous versions of excel I'd go to auto filter and filter
for ends with 00.00...Just tried doing that in the 07 version, and doesn't
seem to work the same.


"dlw" wrote:

> filter on =mod(a1,10)=0
>
> "Ole" wrote:
>
> > 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.
From: Ole on 11 Mar 2010 14:50
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.
>
> .
>
 |  Next  |  Last
Pages: 1 2
Prev: Formula to add up numbers but there are negatives
Next: Tabbing between text boxes in Excel 2007