Dear All,
I attach herewith two worksheets. Sheet 1 gives list of items like Apple, Mango, Banana, Wheat, etc. and there is no limit to their total number. In the second worksheet, only one item to be sorted from 1st worksheet. I want the items Apple, Mango, Banana, to be extracted with formula. (each individual item only once). How it can be done ?
VDS
I attach herewith two worksheets. Sheet 1 gives list of items like Apple, Mango, Banana, Wheat, etc. and there is no limit to their total number. In the second worksheet, only one item to be sorted from 1st worksheet. I want the items Apple, Mango, Banana, to be extracted with formula. (each individual item only once). How it can be done ?
VDS