Find & Insert - Is this possible??

[xhgroup]

Hi all,

This is a great forum.

I have a spreadsheet http://www.xh.com.au/excel/Sums.xls

I want column F to show the codes listed in column C but no duplicate.

Image example - http://www.xh.com.au/excel/links.gif

I have put in an example of how I want the data to show like J8F then next cell down PRA, then next cell down it will look for the next code it doesn't have from column C.

Column C will be frequently changing as codes are added, changed and removed.

I'm not sure if this is possible, but here is the best place to ask.

Thanks in advance for you help.

Regards,

XH...

[davesexcel]

http://www.excelforum.com/showthread...ght=duplicates

Check out this post from a few days ago

[xhgroup]

Thanks everyone.