View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike H[_3_] Mike H[_3_] is offline
external usenet poster
 
Posts: 39
Default Select even or odd numbers

On Dec 26, 8:40*am, HUGO wrote:
From a list of numbers, how can I select even numbers or odd numbers and copy
them in another column?
--
LEON EN LINEA


Hi,

With your list of numbers in column A starting in a1 put this in b1
and drag down as reguired

=ISODD(A1)

Apply an autofilter to the 2 columns and filter on TRUE in column B.
Copy column A and paste elsewhere. Filter on FALSE for even numbers

Mike