How can I filter ofr odd and even values

D

Diana

Hi,

Can I filter Odd and even values in Excel.Is there any formula,
function or filter?

Thanks and Merry Christmas to all
 
H

Harald Staff

Easiest is to use a helper column with a formula like
=MOD(A2,2)

HTH. Best wishes Harald
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Odd and even header and footers with section break 2
Dealing with the error: unable to filter on excel hc home school 0
Sorting and filtering text 0
(headers & footers Issue) I have 2 even pages back to back!! 1
Dates In Excel 5
macro that copies all values of columns in column A 4
How to Always show Filter 1
Book formatting: need to alternate page number on left and right margin for only first page of each 2

Top