filtering

[oldLearner57]

hi community,

can help me solve this filtering...

example:

A
1 [email protected]
2 [email protected]
3 [email protected]
4 [email protected]
5 [email protected]
6 [email protected]
7 [email protected]
8 [email protected]

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

any help?

thanks community

 

[Max]

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

 

[Max]

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
---

 

[Satyendra_Haldaur]

Max is right, u can also use ENDS WITH instead of CONTAINS .

 

[oldLearner57]

thanks Max for the kind guidance



thanks community as well

 

[Max]

Welcome
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:18,600 Files:362 Subscribers:60
xdemechanik