|Humar & DerbyDad03,|
Got both to work finally. My special thanks to both of you for your valuable time. It has been a lot of help and I'm learning at the same time.
I'm going to work on the other 2 columns now. To start with I have a table on a new worksheet on the same excell spreadsheet. It is named dxcc. Column A on that worksheet contains things like the following:
UA-UI1, 3, 4, 6 RA-RZ
UA-UI8, 9, 0 RA-RZ
and so on for about 340 rows.
I want to do basically the same thing as with columns I and J above. For example if a 4J, 4K, 4L, 3Y, etc. is entered in column G, a "1" will be entered automatically in column H. If it is entered again on down the sheet, a "0" will be entered.
Question: do I first need to go to the other sheet and put every one of the "prefixes" on a separate line in liew of the groups as shown above???
I better get to work and see what I can do.