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