filter for even numbers in Excel
 

A previous post covered this but I need a bit more help to complete the task.

I have a list of addresses, formatted with the street number and street name
in separate columns. I need to keep the even-numbered addresses and discard
the odd-numbered ones.

The previous question came up with an answer using the ISEVEN formula but I
think I'm inputting it incorrectly or placing it in the wrong location. If
you can help, please be as specific as possible as I'm not using Excel
formulas every day and have to walk myself through them when I do.

Thanks!
Kirsten

filter for even numbers in Excel
 

Post the formula you're using.
--
Brevity is the soul of wit.


"Kirstensaid" wrote:

A previous post covered this but I need a bit more help to complete the task.

I have a list of addresses, formatted with the street number and street name
in separate columns. I need to keep the even-numbered addresses and discard
the odd-numbered ones.

The previous question came up with an answer using the ISEVEN formula but I
think I'm inputting it incorrectly or placing it in the wrong location. If
you can help, please be as specific as possible as I'm not using Excel
formulas every day and have to walk myself through them when I do.

Thanks!
Kirsten

filter for even numbers in Excel
 

If the first street NUMBER is in A1 use =ISEVEN(A1) this will given either
FALSE or TRUE
On the other hand, --ISEVEN(A1) {that is two negative signs after the =
sign} will give 0 or 1
Copy down the column and not you can sort
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Kirstensaid" wrote in message
...
A previous post covered this but I need a bit more help to complete the
task.

I have a list of addresses, formatted with the street number and street
name
in separate columns. I need to keep the even-numbered addresses and
discard
the odd-numbered ones.

The previous question came up with an answer using the ISEVEN formula but
I
think I'm inputting it incorrectly or placing it in the wrong location. If
you can help, please be as specific as possible as I'm not using Excel
formulas every day and have to walk myself through them when I do.

Thanks!
Kirsten

filter for even numbers in Excel
 

Thanks for your help. Unfortunately, I need some pretty basic information
here to go on.

If I enter =ISEVEN(A1) as a formula in the formula bar for the A1 cell
(where the street number is located) the street number is replaced with 0
whether or not it's an even or an odd number. And it replaces the street
number. Should I copy the street number to a second column to save the record
of that? (I've got to generate address labels when I'm done sorting so I
still need that number.)

Is there something else or somewhere else that I should be putting the
formula, or other characters in front? I'm really at sea here and would
appreciate as much direction as possible.

Thanks!
Kirsten





"Bernard Liengme" wrote:

If the first street NUMBER is in A1 use =ISEVEN(A1) this will given either
FALSE or TRUE
On the other hand, --ISEVEN(A1) {that is two negative signs after the =
sign} will give 0 or 1
Copy down the column and not you can sort
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Kirstensaid" wrote in message
...
A previous post covered this but I need a bit more help to complete the
task.

I have a list of addresses, formatted with the street number and street
name
in separate columns. I need to keep the even-numbered addresses and
discard
the odd-numbered ones.

The previous question came up with an answer using the ISEVEN formula but
I
think I'm inputting it incorrectly or placing it in the wrong location. If
you can help, please be as specific as possible as I'm not using Excel
formulas every day and have to walk myself through them when I do.

Thanks!
Kirsten

filter for even numbers in Excel
 

Oh, beautiful! It worked! Thanks so much!
I created another A1 column to the left to contain the formula and
referenced the B1 cell and it worked! How fabulous is that! Thanks thanks
thanks!
Kirsten


"Bernard Liengme" wrote:

If the first street NUMBER is in A1 use =ISEVEN(A1) this will given either
FALSE or TRUE
On the other hand, --ISEVEN(A1) {that is two negative signs after the =
sign} will give 0 or 1
Copy down the column and not you can sort
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Kirstensaid" wrote in message
...
A previous post covered this but I need a bit more help to complete the
task.

I have a list of addresses, formatted with the street number and street
name
in separate columns. I need to keep the even-numbered addresses and
discard
the odd-numbered ones.

The previous question came up with an answer using the ISEVEN formula but
I
think I'm inputting it incorrectly or placing it in the wrong location. If
you can help, please be as specific as possible as I'm not using Excel
formulas every day and have to walk myself through them when I do.

Thanks!
Kirsten

filter for even numbers in Excel
 

Glad to be of help
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Kirstensaid" wrote in message
...
Oh, beautiful! It worked! Thanks so much!
I created another A1 column to the left to contain the formula and
referenced the B1 cell and it worked! How fabulous is that! Thanks thanks
thanks!
Kirsten


"Bernard Liengme" wrote:

If the first street NUMBER is in A1 use =ISEVEN(A1) this will given
either
FALSE or TRUE
On the other hand, --ISEVEN(A1) {that is two negative signs after the =
sign} will give 0 or 1
Copy down the column and not you can sort
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Kirstensaid" wrote in message
...
A previous post covered this but I need a bit more help to complete the
task.

I have a list of addresses, formatted with the street number and street
name
in separate columns. I need to keep the even-numbered addresses and
discard
the odd-numbered ones.

The previous question came up with an answer using the ISEVEN formula
but
I
think I'm inputting it incorrectly or placing it in the wrong location.
If
you can help, please be as specific as possible as I'm not using Excel
formulas every day and have to walk myself through them when I do.

Thanks!
Kirsten