Posted to microsoft.public.excel.misc
|
|
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 "
|