filtering

  • Thread starter Thread starter oldLearner57
  • Start date Start date
O

oldLearner57

hi community,

can help me solve this filtering...

example:

A
1 (e-mail address removed)
2 (e-mail address removed)
3 (e-mail address removed)
4 (e-mail address removed)
5 (e-mail address removed)
6 (e-mail address removed)
7 (e-mail address removed)
8 (e-mail address removed)

how can i filter out only those from "@yahoo.com"

any help?

thanks community :)
 
Insert a top row, place this in B2, copy down:
=IF(ISNUMBER(SEARCH("@yahoo.com",A2)),"x","")
Then apply autofilter on col B, choose: x from the dropdown in B1
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:18,400 Files:361 Subscribers:58
xdemechanik
 
Actually you can use autofilter directly on col A's data
Just insert a new top row, then apply Autofilter on col A
Choose "Custom" from the dropdown in A1
In the Custom Autofilter dialog:
Choose "Contains", & input the search string: @yahoo.com
Click OK
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:18,400 Files:361 Subscribers:58
xdemechanik
---
 
Back
Top