filtering for numbers ending in 000

[bigjackblack999]

Hi,

I have been given a task of running a query across 45000 lines of excel to
show only numbers that are rounded to thousands. (i do not want to round
numbers, just report on existing 000's). i have no idea how to do this. i
tried using adavanced auto filter - greater than 999 and ending in 000, but
no results were returned. This is probably simple to do but i have no idea.
(also do not want to bring back numbers with 000 in middle eg 500043, just
ending in 000).
any help would be greatly appreciated,

Thanks, novice user getting frustrated.

 

[Jarek Kujawa]

try:

=IF(RIGHT(A1,3)="000","full thousand","")

and apply autofilter on "full thousand"

 

[Bob Phillips]

Try adding a formula in a helper column and filter on the helper column

So assuming the numbers are in column E, in your helper columne row 2 enter

=MOD(E2,1000)=0

Copy this down, then filter the helper column for TRUE

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[bigjackblack999]

Hi, this fixed it. thanks very much. (less frustrated novice user)