filter out
 

I have a worksheet that I've imported a report into (useing docview, if it
matters)... The report consists of building reserve locations and any items
that may be in that location. Both loc. and item info. are in the same
column (hense needing to use a formula to sort out the page info. & report
title info. that gets imported with it). First listed is the reserve
location then followed by item information if any exsists for that location
ie. HH115a
315948
HH115b
HH115c
459834
NC4879
HH115d .... etc.

I'm useing columns A-j with reserve info and K-M for sorting formula.

What I would like to do is keep just keep the A & B levels or C through S
levels. I tried to mess around with some forumlas but anything i came up
with resulted in faulty values or improper formulas (new to useing formulas
in excel/vb novice). If this is at all possible in formula or vba code it
would be much appricated for some insight.