How I can do that by MS-Excel:? - best loli list
my boss asked me to do and so many do not know how:
I started this list with the names in the first column:
Jack
Sami
loli
lala
Meme
Then the next column, I randomly selected some of these names and write them in a row and I need that excellence for the names I have not written and put to find in series. Open the link below to see how.
http://mypictures2008.blogspot.com/
Best Loli List How I Can Do That By MS-Excel:?
1 comments:
When you have finished your work, it will be a list of names in column A and some of these names are repeated in line 1, where an empty cell, prior to the last row.
You want a macro to the complete line 1, column names that are more in line 1. As the name in cell A1 and is in line 1, which have never been on the line 1 resumed. The macro does not delete the duplicates in row 1 or names on the line 1, which is missing in Colunm A.
Place the following code in a module project and decide how you want to run.
Finish Names (sub-)
ICol iRow As Long
Active Sheet
iRow = 2
Do While. Cells (iRow, 1)> ""
iCol = 2
Do While. Cells (1, iCol)> ""
Si Cells (iRow, 1) =. Cells (1, iCol) Then Exit Do
iCol = iCol + 1
Loop
Si Cells (1, iCol) = "" Then. Cells (1, iCol) =. Cells (iRow, 1)
IRow = iRow + 1
Loop
End With
End Sub
If you want theName in cell A1 again somewhere along the line 1, you simply change the statement iRow iRow = 2 = 1.
Further details can be modified PLA from someone who knows
Post a Comment