Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filter text in a column by its Indent, to remove certain text
I want to filter text in a column by its indent. The format is such that
each cell has text in it which is indented from the text above up to 8 indents. The sequence is then repeated. I want to filter out the 5th to the 8th indents from the range. Any ideas. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filter text in a column by its Indent, to remove certain text
Hi 99TZ250,
I want to filter text in a column by its indent. The format is such that each cell has text in it which is indented from the text above up to 8 indents. The sequence is then repeated. I want to filter out the 5th to the 8th indents from the range. Perhaps you could use the Advanced filter on a helper column in which you use the following User Defined Function: '============= Public Function GetIndent(rng As Range) As Long GetIndent = rng.IndentLevel End Function '<<============= If you are not familiar with macros, you may wish to visit David McRitchie's 'Getting Started With Macros And User Defined Functions' at: http://www.mvps.org/dmcritchie/excel/getstarted.htm --- Regards, Norman |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Format as a MACRO | Excel Worksheet Functions | |||
creating a bar graph | Excel Discussion (Misc queries) | |||
Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions | |||
advanced filter - can't match a long text cell | Excel Discussion (Misc queries) | |||
Filter long Text strings | Excel Worksheet Functions |