Forecasting ability

[BenjaminLim]

I need help to filter out numbers that had occurred before.<br><br><b><font color=blue> Example : 23, 42, 54, 24, etc </b></font><br><br>I want to be able to exclude the above list stored in a table (let's call it table A) from another bigger table (the overall list - this list stores number from 0 to 99 & is unique - let's call it Table B).<br><br>Table A grows periodically and in the above example 24 & 42 are considered to be the same (i.e. how big is not important) & so the final filtered list should not contain both 24 & 42.<br><br>Pls advice how should I go about the above problem.

 

[DougP]

Not sure I follow.<br>&nbsp;but if you want to elimnate soemthign then you have to keep track of it. right.<br>So create another table that you add numbers to. and then look at that table to see if something is there or not.<br><br>I don't know if you are doing this with VBA code or what so I can't advise beyond that. <p>DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br> Ask me how Bar-codes can help you be more productive.