# Help to check if element in [array A] is made up by sum of some elements in [array B]

• Good evening! Members in forum

Can you help me to solve this problem by VBA

I have two arrays like picture below (example), I want to check if element in array A is made up of sum of two or more elements in array B. Sum of elements in array A equal to elements in array B.

This example can be described:

Option Base 1 [The first ordinary element in array is 1]

Loop through elements in array A, we find that

A[1] = B[1] + B[3] + B[4], ==> A[1] & B[1]; B[3]; B[4] will be eliminated.

A[2] = 30 can't not be result of sum of two or more remains. [5,10,10,24,13] ==> They are ignored

A[3] = B[2] + B[5] ==> A[3] & B[2]; B[5] will be eliminated.

A[4] = 17 can't not be result of sum of two or more remains. [10,24,13] ==> They are ignored

So we have A[1] = 0, A[2] = 30 , A[3] = 0, A[4] = 17

B[1] = B[2] = B[3] = B[4] = B[5] = 0, B[6] = 10, B[7] = 24, B[8] = 13

Two array is a simple example, Can any one help me with many elements Array? Thank

## Images

• Hello And Welcome to the Forum

This topic has been tackled (and solved) a huge number of times ...

Hope this will help

If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner

• Thanks Mr/Ms Carim

Because my English is not well, so I don't know how to choose right key words to search

Thank you so much many many times

• You are welcome

If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner