odd even house address list

[wpc]

I have an xls sheet with street addresses in each row. Assuming that the house number is in colum A, I would like to be able to copy the rows of odd number homes to one sheet and those of even number homes to another sheet. I am using excel 2007 which supports iseven and is odd function. =IF(ISEVEN(A1), A1,"") and =IF(ISODD(A1), A1,"") will give me the odd and even house numbers but I don't know where to go from here.

Thanks

 

[VoG]

Hello and welcome to MrExcel.

Take a look here Excel Explosion

 

[mikerickson]

AdvancedFilter with a function based criteria range will do what you want.

If your data is in Sheet1!A1:B10 (with a header in A1) and Sheet1!C:C is empty:
Leave Sheet1!D1 empty, put =ISEVEN(A2) in Sheet1!D2

Activate the sheet that you want the even numbers to go (Sheet2).
Press AdvancedFilter, check the Copy to other location box and use

Data Range: Sheet1$A$1:$B$10
Criteria range: Sheet1!$D$1:$D$2
Copy to range: Sheet2!$A$1

Done.
Use a different sheet and the formula =ISODD(A2) for the odd numbers records.