tried a few times getting formulas or a pivot table to work.
here is an example http://www.crlaurence.com/adv/example.xls
trying to enter something into cell A2 (like A12* or A123)
then it would look at column G, and then find all matches, and in order display column H and I info and...