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.

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

Ctrl+H > Options >
Find what: -Format > Choose format from cell > choose your cell (with n number of indents);
Replace with: -Format > Format > Fill > Backgroud color

After replacing indents with bgcolor, you can easily filter

I have 350,000 subscribers, all CPAs, CFOs, controllers, Finance and Treasury exectuives, and many of the lists or spreadsheets they send have varying number of indents.

My Medicare brain would NEVER understand or remember the VBA or macro so changing the background based on number of indents is my kind of solution.

THANKS.

Gary Zeune, CPA
Managing Director
The Pros & The Cons
World's Only Speakers Bureau for White Collar Criminal