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... :)


--
xhgroup
------------------------------------------------------------------------
xhgroup's Profile: http://www.excelforum.com/member.php...o&userid=32471
View this thread: http://www.excelforum.com/showthread...hreadid=522581

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

Check out this post from a few days ago


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=522581

Thanks everyone.


--
xhgroup
------------------------------------------------------------------------
xhgroup's Profile: http://www.excelforum.com/member.php...o&userid=32471
View this thread: http://www.excelforum.com/showthread...hreadid=522581