Hello,

I'm hoping that someone can help me with this problem.

I have a spreadsheet where I am dumping raw data into one worksheet,
and I want another 2 worksheets to look at that data and list out all
of the information pertaining to their criteria.

the Data worksheet (which is the suspense) contains sequence numbers,
dates, vendor ID's and a host of other information. In column A, I have
plucked out the first letter of the Vendor ID. (what I am trying to
achieve - the first worksheet lets call it "first" look up all records
that begin with an "A"or "B" or "C" or "D" up to "I" and list the
records one by one down the page WITHOUT DUPLICATION, then the second
worksheet lets call it "second" will list all of the remaining
alphabet's "J" to "Z".

I have managed to get part of the way there through this formula:
=IF(ISERROR(INDEX(Suspense!$A$2:$K$139,SMALL(IF(Su spense!$A$2:$A$139="A",ROW(Suspense!$A$2:$A$139)), ROW(Suspense!1:1)),2)),"",(INDEX(Suspense!$A$2:$K$ 139,SMALL(IF(Suspense!$A$2:$A$139="A",ROW(Suspense !$A$2:$A$139)),ROW(Suspense!1:1)),2)))

However I can only look at one criteria at a time, i.e. "A" first then
"B". I would really like to get the formula to work right straight away
with no messing around.

So.... by using the formula above, I have split my criteria into lines
of 100. All the "A"'s are looked up in rows 2-101, "B"'s are rows
102-202 etc.

If there is no way of completing this formula in one go, is it possible
to Look up the results on "first" and reference them on a new
worksheet, where all information is copied across, and all blanks are
skipped?

Any help would be great!!!

Thanks
Excel_OZ