My suggestion is to use Advanced filter:
Choose an empty helper column for criteria range, say Z!
Leave empty Z1, enter formula in Z2
=MOD(ROW(A2),2)=0 for even
=MOD(ROW(A2),2)=1 for odd row No!
Data/Filter/Advanced filter/Enter your used range as list range, Z1:Z2 as
criteria range/click OK!
Regards,
Stefi
„mmcclain†ezt Ãrta: