Hi,
I have a number in A2 [0400000000] and another number in A3 [0401000000].
I have a list of numbers in another column - B - each of which are also between these two numbers in A1 & A2.
How do I print out in Column C all the numbers available between A2 & A3 that have not been used already in Column B?
Furthermore - as we use available numbers from Column C they will be added to the end of the list in Column B - so the available numbers in Column C should dynamically adjust when a number is added to Column B.
thx in advance !!
I have a number in A2 [0400000000] and another number in A3 [0401000000].
I have a list of numbers in another column - B - each of which are also between these two numbers in A1 & A2.
How do I print out in Column C all the numbers available between A2 & A3 that have not been used already in Column B?
Furthermore - as we use available numbers from Column C they will be added to the end of the list in Column B - so the available numbers in Column C should dynamically adjust when a number is added to Column B.
thx in advance !!