ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Find & Insert - Is this possible?? (https://www.excelbanter.com/excel-discussion-misc-queries/77398-find-insert-possible.html)

xhgroup

Find & Insert - Is this possible??
 

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


davesexcel

Find & Insert - Is this possible??
 

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


xhgroup

Find & Insert - Is this possible??
 

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



All times are GMT +1. The time now is 08:30 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com