You don't really say what kind of 'list' you are looking for, but if you
want to have a grid layout with the store listed below the Product that
is "Incorrect", use this formula format: (where column A is your list
of stores, beginning in row 2, and your products are listed in
B1:nn1.)
In another area of your sheet (or a new sheet) build a matching grid to
this data grid and enter this formula in B2 and copy down and over as
needed to fill the grid:
=IF(ISERROR(MATCH("Incorrect",B2,0)),"",$A2)
The result will be the name of the store (from col. A) in each cell
beneath the Product name that holds an 'Incorrect' value.
Does this work for you?
Bruce
--
swatsp0p
------------------------------------------------------------------------
swatsp0p's Profile:
http://www.excelforum.com/member.php...o&userid=15101
View this thread:
http://www.excelforum.com/showthread...hreadid=380847