Dear Excel gurus
I have created a sheet which consists of Container number and series of item and counts which are the results of the vlookup from 3 different sheets. Now I would like to scan this matrix and create a another sheet with container no. and one item and count column which will have the actual values other than #NA.
How can I create this sheet? What formula/function should I use to create it?
Thanks
Bookmarks