odd-even sorting or filtering

  • Thread starter Thread starter LD71
  • Start date Start date
L

LD71

I apologise if this has been covered previously, I am new to thi
forum.

I have a large list, column A has an id number, column B has an e-mai
address. I want to delete the odd-numbered id's, so I can work wit
just the even-numbered e-mails. Any help would be appreciated

Larr
 
Hi
add a helper column (lets say column C) and enter the following in C1
=MOD(A1,2)
copy down

now filter (use autofilter from 'Data - Filter') all rows with a '1' in
column C and delete these rows
 
Back
Top