hi community,

can help me solve this filtering...

example:

A
1
2
3
4
5
6
7
8

how can i filter out only those from "

any help?

thanks community :)
--
oldLearner57

Insert a top row, place this in B2, copy down:
",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
---
"oldLearner57" wrote:
A
1
2
3
4
5
6
7
8

how can i filter out only those from "

thanks Max for the kind guidance

:)

thanks community as well
--
oldLearner57


"Max" wrote:

Insert a top row, place this in B2, copy down:
",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
---
"oldLearner57" wrote:
A
1
2
3
4
5
6
7
8

how can i filter out only those from "

Welcome
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:18,600 Files:362 Subscribers:60
xdemechanik
---
"oldLearner57" wrote in message
...
thanks Max for the kind guidance

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

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

"Max" wrote:

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