Hallo Everyone;
I would to like find a solution for the long process that I have to go
through allday.
width height length width height length
1. Box 180 130 130 1. Box 75 75 240
2. Box 300 250 200 2. Box 180 180 180
3. Box 315 215 155 3. Box 210 210 490
4. Box 320 320 175 4. Box 250 250 200
5. Box 395 200 160 5. Box 285 285 120
6. Box 430 430 85 6. Box 430 85 430
7. Box 440 350 260 7. Box 650 650 520

Above, you can see the dimensions of different types of boxes. And in my
list there are thousands of datas of different types of boxes. Boxes on the
left side are in my system, boxes on the right side are the new coming
ones.I'd like to know if there are any matching boxes (one from right side,
the other one from left side), what I mean is if the dimensions are same..!
Please note that if the volume is same, they are the same box. (for example:
for the sixth boxes height and lenghts are contrary written. )

Suppose you have the below data in 2 sheets..

Sheet1 contains the existing list of boxes ColA to ColD
Sheet2 contains the new list of boxes ColA to ColD

In Sheet2 cell E2 apply the below formula and copy down as required. Please
note that this is an array formula.You create array formulas in the same way
that you create other formulas, except you press CTRL+SHIFT+ENTER to enter
the formula. If successful in 'Formula Bar' you can notice the curly braces
at both ends like "{=<formula}"

=IF(ISNA(MATCH(D2*C2*B2,Sheet1!$B$1:$B$10*Sheet1!$ C$1:$C$10*
Sheet1!$D$1:$D$10,0)),"New","Already Exist")

OR

With volume calculated in Sheet1 ColE; try the below non-array formula in
Sheet2 cell E2 and copy down as required...
=IF(ISNA(MATCH(D2*C2*B2,Sheet1!E:E,0)),"New","Alre ady Exist")


The result would be
Col A Col B Col C Col D Col E
width height length Status
1. Box 75 75 240 New
2. Box 180 180 180 New
3. Box 210 210 490 New
4. Box 250 250 200 New
5. Box 285 285 120 New
6. Box 430 85 430 Already Exist
7. Box 650 650 520 New


--
Jacob


"cancan" wrote:

Hallo Everyone;
I would to like find a solution for the long process that I have to go
through allday.
width height length width height length
1. Box 180 130 130 1. Box 75 75 240
2. Box 300 250 200 2. Box 180 180 180
3. Box 315 215 155 3. Box 210 210 490
4. Box 320 320 175 4. Box 250 250 200
5. Box 395 200 160 5. Box 285 285 120
6. Box 430 430 85 6. Box 430 85 430
7. Box 440 350 260 7. Box 650 650 520

Above, you can see the dimensions of different types of boxes. And in my
list there are thousands of datas of different types of boxes. Boxes on the
left side are in my system, boxes on the right side are the new coming
ones.I'd like to know if there are any matching boxes (one from right side,
the other one from left side), what I mean is if the dimensions are same..!
Please note that if the volume is same, they are the same box. (for example:
for the sixth boxes height and lenghts are contrary written. )