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

Quote from Carim

Hello And Welcome to the Forum

Have you searched or ' googled ' your question ...?

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

see : https://www.extendoffice.com/d…that-equal-given-sum.html

Hope this will help

Display More

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