TNO Bid_2.xlsm
Hi,
So I have a column as so
1213
12324
5675
56
46
56567
etc
etc
And on another sheet I have a large array (30x30) of which I want to clear cell values that equal the cells in the above column. This is what I have tried so far;
Which for some reason deletes a whole host of values (but not the ones it should!). Not sure what I am doing wrong.
I should point out that the cell values in both arrays are formatted as TEXT (despite being numbers - it was the only way round a certain procedure). I think this may be causing issues.
Help is appreciated.
Bookmarks