you can do an advanced sort - to filter out unique records

HTH

"Eric @ BP-EVV" wrote:

I think I'm making this much harder than it should be so I thought I'd ask
this forum for some advice. I've got a spreadsheet that looks something like
this:

location item# weight
A 1 0.75
B 1 0.75
c 1 0.925
A 2 1.5
B 2 1.5
C 2 1.5
A 3 2.25
A 4 5.75

There can be up to 20 location codes and any number of items, with weights
that may or may not match. What I am trying to do is loop through the data
to determine for all item # if the weight identical for all locations. If
true (or if the item exists at only one location) I want to copy that data to
tab in the workbork named "weight OK" - if false I want to copy that data to
a tab in the workbook named "weight exception". The data is sorted already
by Item# & location.

I seem to be suffering from some sort of "writers block" on this...can
anyone provide some suggestions ?

Thanks !