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
|