Posts by lopapa

    Hi can you help me to get the formula how to count the duplicate value: E.g.


    [TABLE="width: 141"]

    [tr]


    [td]

    Number

    [/td]


    [td]

    count

    [/td]


    [/tr]


    [tr]


    [TD="align: right"]7738360[/TD]
    [TD="align: right"]1[/TD]

    [/tr]


    [tr]


    [TD="align: right"]7738360[/TD]
    [TD="align: right"]2[/TD]

    [/tr]


    [tr]


    [TD="align: right"]7738360[/TD]
    [TD="align: right"]3[/TD]

    [/tr]


    [tr]


    [TD="align: right"]7311048[/TD]
    [TD="align: right"]1[/TD]

    [/tr]


    [tr]


    [TD="align: right"]7311048[/TD]
    [TD="align: right"]2[/TD]

    [/tr]


    [tr]


    [TD="align: right"]43731[/TD]
    [TD="align: right"]1[/TD]

    [/tr]


    [tr]


    [TD="align: right"]43731[/TD]
    [TD="align: right"]2[/TD]

    [/tr]


    [tr]


    [TD="align: right"]43731[/TD]
    [TD="align: right"]3[/TD]

    [/tr]


    [tr]


    [TD="align: right"]43731[/TD]
    [TD="align: right"]4[/TD]

    [/tr]


    [tr]


    [TD="align: right"]43731[/TD]
    [TD="align: right"]5[/TD]

    [/tr]


    [tr]


    [TD="align: right"]43731[/TD]
    [TD="align: right"]6[/TD]

    [/tr]


    [tr]


    [TD="align: right"]38360[/TD]
    [TD="align: right"]1[/TD]

    [/tr]


    [tr]


    [TD="align: right"]38360[/TD]
    [TD="align: right"]2[/TD]

    [/tr]


    [tr]


    [TD="align: right"]38360[/TD]
    [TD="align: right"]3[/TD]

    [/tr]


    [tr]


    [TD="align: right"]4777[/TD]
    [TD="align: right"]1[/TD]

    [/tr]


    [tr]


    [TD="align: right"]4777[/TD]
    [TD="align: right"]2[/TD]

    [/tr]


    [/TABLE]

    Hi Guys! Can you please modify my code below:


    So I can get all the data and tranfer to a new workbook


    For ex: Column: A, B, and C
    Column Name - First name Last name Nickname
    Row Value: Kevin, Durant, KD
    Kobe, Bryant, Blackmamba
    Michael, Jordan, Air Jordan : the out should be transfer all the value to anothe Workbook - My code only transfer the FIRST LINE which is Kobe bryan Black mamba :( Can you please help me


    [TABLE="width: 215"]

    [tr]


    [td]

    First name

    [/td]


    [td]

    Last name

    [/td]


    [td]

    Nickname

    [/td]


    [/tr]


    [tr]


    [td]

    Kobe

    [/td]


    [td]

    Bryan

    [/td]


    [td]

    Black Mamba

    [/td]


    [/tr]


    [tr]


    [td]

    Kevin

    [/td]


    [td]

    Durant

    [/td]


    [td]

    KD

    [/td]


    [/tr]


    [tr]


    [td]

    Michael

    [/td]


    [td]

    Jordan

    [/td]


    [td]

    Air Jordan

    [/td]


    [/tr]


    [/TABLE]




    Hi guys!


    Please help.


    I'm trying to transfer all of my value to new a woorkbook however the only value that transfer to is on the 2second column. Can you pls help me.


    For ex: A B C
    Column - First name Last name Nickname
    Row: Kevin Durant KD
    Kobe Bryant Blackmamba


    Will transfer to another Workbook which I already figure it out.


    #Sub Button2_Click()


    Dim fName As String
    Dim lName As String
    Dim mName As String



    Worksheets("Sheet1").Select
    fName = Range("A2")
    Worksheets("Sheet1").Select
    lName = Range("b2")
    Worksheets("Sheet1").Select
    mName = Range("c2")



    Set myData = Workbooks.Open("C:\DATA\Output.xlsx")
    Worksheets("Sheet1").Select
    Worksheets("Sheet1").Range("a2").Select
    RowCount = Worksheets("Sheet1").Range("A1").CurrentRegion.Rows.Count



    With Worksheets("Sheet1").Range("a2")
    .Offset(ColumnCount, 0) = fName
    .Offset(ColumnCount, 1) = lName
    .Offset(ColumnCount, 2) = mName



    End With



    myData.Save





    End Sub



    #

    Hi All.


    I need your help.


    Here is the concept of my assignment.


    I need to use a Macro..


    The problem is


    There are 3 sheet.


    sheet1 -


    [TABLE="width: 147"]

    [tr]


    [td]

    Sam2

    [/td]


    [TD="align: right"]96[/TD]

    [/tr]


    [tr]


    [td]

    Sam2

    [/td]


    [TD="align: right"]95[/TD]

    [/tr]


    [tr]


    [td]

    Sam2

    [/td]


    [TD="align: right"]99[/TD]

    [/tr]


    [tr]


    [td]

    Sam2

    [/td]


    [TD="align: right"]79[/TD]

    [/tr]


    [tr]


    [td]

    Sam2

    [/td]


    [TD="align: right"]78[/TD]

    [/tr]


    [tr]


    [td]

    Sam2

    [/td]


    [TD="align: right"]80[/TD]

    [/tr]


    [/TABLE]



    sheet2
    [TABLE="width: 147"]

    [tr]


    [td]

    Department

    [/td]


    [td]

    Score

    [/td]


    [/tr]


    [tr]


    [td]

    Sam3

    [/td]


    [TD="align: right"]95[/TD]

    [/tr]


    [tr]


    [td]

    Sam3

    [/td]


    [TD="align: right"]95[/TD]

    [/tr]


    [tr]


    [td]

    Sam3

    [/td]


    [TD="align: right"]93[/TD]

    [/tr]


    [tr]


    [td]

    Sam3

    [/td]


    [TD="align: right"]80[/TD]

    [/tr]


    [tr]


    [td]

    Sam3

    [/td]


    [TD="align: right"]87[/TD]

    [/tr]


    [tr]


    [td]

    Sam3

    [/td]


    [TD="align: right"]98[/TD]

    [/tr]


    [/TABLE]


    sheet3 - The output



    I need to use a button here:
    so the out will be:
    [TABLE="width: 96"]

    [tr]


    [TD="width: 64, bgcolor: transparent"]Sam2[/TD]
    [TD="width: 64, bgcolor: transparent, align: right"]99[/TD]

    [/tr]


    [tr]


    [TD="bgcolor: transparent"]Sam2[/TD]
    [TD="bgcolor: transparent, align: right"]96[/TD]

    [/tr]


    [tr]


    [TD="bgcolor: transparent"]Sam2[/TD]
    [TD="bgcolor: transparent, align: right"]95[/TD]

    [/tr]


    [tr]


    [TD="bgcolor: transparent"]Sam3[/TD]
    [TD="bgcolor: transparent, align: right"]98[/TD]

    [/tr]


    [tr]


    [TD="bgcolor: transparent"]Sam3[/TD]
    [TD="bgcolor: transparent, align: right"]95[/TD]

    [/tr]


    [tr]


    [TD="bgcolor: transparent"]Sam3[/TD]
    [TD="bgcolor: transparent, align: right"]95[/TD]

    [/tr]


    [/TABLE]


    Any suggention guys? please help me.

    Hi new here.


    I'm currently creating my Macro. Can you please help me!


    Here is the scenario: I need to get the Top 3 for each departement.


    Sheet 1:


    [TABLE="width: 147"]

    [tr]


    [td]

    Department

    [/td]


    [td]

    Score

    [/td]


    [/tr]


    [tr]


    [td]

    Sam3

    [/td]


    [TD="align: right"]95[/TD]

    [/tr]


    [tr]


    [td]

    Sam3

    [/td]


    [TD="align: right"]95[/TD]

    [/tr]


    [tr]


    [td]

    Sam3

    [/td]


    [TD="align: right"]93[/TD]

    [/tr]


    [tr]


    [td]

    Sam3

    [/td]


    [TD="align: right"]80[/TD]

    [/tr]


    [tr]


    [td]

    Sam3

    [/td]


    [TD="align: right"]87[/TD]

    [/tr]


    [tr]


    [td]

    Sam3

    [/td]


    [TD="align: right"]98[/TD]

    [/tr]


    [tr]


    [td]

    Sam2

    [/td]


    [TD="align: right"]96[/TD]

    [/tr]


    [tr]


    [td]

    Sam2

    [/td]


    [TD="align: right"]95[/TD]

    [/tr]


    [tr]


    [td]

    Sam2

    [/td]


    [TD="align: right"]99[/TD]

    [/tr]


    [tr]


    [td]

    Sam2

    [/td]


    [TD="align: right"]79[/TD]

    [/tr]


    [tr]


    [td]

    Sam2

    [/td]


    [TD="align: right"]78[/TD]

    [/tr]


    [tr]


    [td]

    Sam2

    [/td]


    [TD="align: right"]80[/TD]

    [/tr]


    [/TABLE]




    The output will be in the sheet 2.


    [TABLE="width: 96"]

    [tr]


    [TD="width: 64, bgcolor: transparent"]Department[/TD]
    [TD="width: 64, bgcolor: transparent"] Score[/TD]

    [/tr]


    [tr]


    [TD="bgcolor: transparent"]Sam3[/TD]
    [TD="bgcolor: transparent, align: right"]98[/TD]

    [/tr]


    [tr]


    [TD="bgcolor: transparent"]Sam3[/TD]
    [TD="bgcolor: transparent, align: right"]95[/TD]

    [/tr]


    [tr]


    [TD="bgcolor: transparent"]Sam3[/TD]
    [TD="bgcolor: transparent, align: right"]95[/TD]

    [/tr]


    [tr]


    [TD="bgcolor: transparent"]Sam2[/TD]
    [TD="bgcolor: transparent, align: right"]99[/TD]

    [/tr]


    [tr]


    [TD="bgcolor: transparent"]Sam2[/TD]
    [TD="bgcolor: transparent, align: right"]96[/TD]

    [/tr]


    [tr]


    [TD="bgcolor: transparent"]Sam2[/TD]
    [TD="bgcolor: transparent, align: right"]95[/TD]

    [/tr]


    [/TABLE]

    Re: Top 10


    Hi.


    I want to use VBA.


    For example.


    Sheet1 Column A The value are


    6
    7
    20
    34
    54
    65
    76
    345
    65
    34
    56
    5345


    and then I will add a button in sheet2 so when I click the button the output will be in the column a sheet2 is


    [TABLE="width: 48"]

    [tr]


    [TD="class: xl63, width: 64, bgcolor: transparent, align: right"]5345[/TD]

    [/tr]


    [tr]


    [TD="class: xl63, bgcolor: transparent, align: right"]345[/TD]

    [/tr]


    [tr]


    [TD="class: xl63, bgcolor: transparent, align: right"]76[/TD]

    [/tr]


    [tr]


    [TD="class: xl63, bgcolor: transparent, align: right"]65[/TD]

    [/tr]


    [tr]


    [TD="class: xl63, bgcolor: transparent, align: right"]65[/TD]

    [/tr]


    [tr]


    [TD="class: xl63, bgcolor: transparent, align: right"]56[/TD]

    [/tr]


    [tr]


    [TD="class: xl63, bgcolor: transparent, align: right"]54[/TD]

    [/tr]


    [tr]


    [TD="class: xl63, bgcolor: transparent, align: right"]34[/TD]

    [/tr]


    [tr]


    [TD="class: xl63, bgcolor: transparent, align: right"]34[/TD]

    [/tr]


    [tr]


    [TD="class: xl63, bgcolor: transparent, align: right"]20
    Thanks !!
    [/TD]

    [/tr]


    [/TABLE]

    Hi Guys,


    I need you help.


    Can you help me getting the top 10:


    For example


    Column A


    I have


    11
    10
    9
    8
    7
    6
    7
    5
    5
    3
    2


    and i need to get the top10 and transfer it to sheet2
    so the output should be


    11
    10
    9
    8
    7
    6
    7
    5
    5
    3
    2


    Thanks for your help