Thread: filtering
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
oldLearner57 oldLearner57 is offline
external usenet poster
 
Posts: 119
Default filtering

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 "