Hi JHB, so basically I want to be able to create a criteria in either access or excel where I would be able to find a BIN in all records and based on that BIN I want to put particular elements into a new table and so on going across. For example, if I am looking for BIN 1234, there are duplicate records under the BIN field with that same number so I want to find that BIN and move on to the next criteria for a particular cell/value and find multiple elements from the next field, so say the elements I am looking for include 1,2,3 and 4. Each element is entered in its own record so I am trying to create a criteria/code in either access or excel to find BIN 1234 for elements 1,2,3 and 4 for one particular cell. I am sure I will be able to duplicate this code once I am able to find the correct code for one cell. Please Help!
And just to clear which data are included, I am looking for a simple math equation once I am able to find my desired data. I am looking for the percentage makeup of cs3 and cs4 out of the entire sum quantity. So it would be ((cs3+cs4)/sum quantity)*100