I need help creating a formula. I have an Excel 2003 Worksheet that contains
information. I would like the formula to look at the column ProductID where
this column contains numerical information and the same number could be
listed in this column more than once. So I would like the formula to look at
the ProductID, Count & QOH columns. If the ProductID value is listed more
than once it would go to the count column add up the amount and verify that
it matches what is listed in the QOH if not then move that ProductID, Count
& QOH and Area which is on this worksheet to a new sheet. Example is as
follows:
ProductID Count QOH
1234 4 5
1234 1 5

So the formula would look at the 1234 which is listed twice and now total
the Count and Verify with QOH that it matches which it does so it would do
nothing. Now the next example is what I would like it to do if it does not
match:
ProductID Count QOH
5678 2 10
5678 4 10
5678 1 10
So now the formula would look at the '5678' go to the Count column total
that up which the results would be 7, look at the QOH column which is 10.
Does not match so it would move the information from the worksheet to a new
sheet. If a formula would not work for this is there another way of
gathering this information? Thank You in advance for your help and time.


--
kwall