filter for round numbers
 

Is there a way to filter or sort for only those values that have no cents? I
have a column of discount amounts, and I want to see only the flat rate
discounts and not the percentage discounts. The flat rate discounts would be
like 25.00 <-- always without any cents. Percentage discounts would
virtually always be like 25.34 or something like that.
Thanks!
Julie

filter for round numbers
 

You can use a helper column with a formula like this:

=IF(INT(D2)=D2,"Flat-rate","%age")

and copy this down. Then you can apply autofilter to this column,
selecting "Flat-rate" from the filter pull-down.

Hope this helps.

Pete

On Sep 23, 2:38*pm, Julieeeee
wrote:
Is there a way to filter or sort for only those values that have no cents? *I
have a column of discount amounts, and I want to see only the flat rate
discounts and not the percentage discounts. *The flat rate discounts would be
like 25.00 <-- always without any cents. *Percentage discounts would
virtually always be like 25.34 or something like that.
Thanks!
Julie

filter for round numbers
 

Assuming that the 25 is 25 and not soemthing like 24.999999999994 as the
result of a calculation the use a helper column with the formula:

=E4=INT(E4)

or whatever the column/row is and copy down then filter of TRUE.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Julieeeee" wrote in message
...
Is there a way to filter or sort for only those values that have no cents?
I
have a column of discount amounts, and I want to see only the flat rate
discounts and not the percentage discounts. The flat rate discounts would
be
like 25.00 <-- always without any cents. Percentage discounts would
virtually always be like 25.34 or something like that.
Thanks!
Julie