Perhaps this could be an option ..
Source data in Sheet1's cols A and B, from row2 down
In Sheet2,
Assume Store # will be input in B1
In A2:
=IF(Sheet1!A2="","",IF(Sheet1!A2=$B$1,ROW(),""))
Leave A1 empty
In B2:
=IF(ROW(A1)COUNT(A:A),"",INDEX(Sheet1!B:B,SMALL(A :A,ROW(A1))))
Select A2:B2, copy down to cover the max expected extent of data in Sheet1.
Hide away col A. Col B returns the required results all neatly bunched at the
top.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"David B" wrote:
Dave,
Thanks for your quick reply and excellent suggestion...unfortunately, my
ultimate use for this spreadsheet for for implimentation in a Crystal
Xcelsius dashboard, and Xcelsius will not work with a pivot table (at least
not that I can determine)...
I'm trying to work with some combination of Match and Index
functions..."Offset" is also not compatible with Xcelsius...