filter a list of numbers
 

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.

filter a list of numbers
 

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" skrev i meddelelsen
...
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.

filter a list of numbers
 

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.

filter a list of numbers
 

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.

filter a list of numbers
 

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" skrev i meddelelsen
...
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.

.

filter a list of numbers
 

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" skrev i meddelelsen
...
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.

.