Results 1 to 6 of 6

Thread: EXCEL

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Registered User
    Join Date: Jun:2010
    Location: .
    Posts: 55

    EXCEL

    , EXCEL .
    - . , , .
    excel .
    Find , .

    - , . , , .
    &, , & TRIM .

    . excel .

  2. #2
    -==-
    Join Date: Sep:2003
    Location:
    Posts: 6,444
    - .
    , vlookup.
    He who asks is a fool for five minutes, but he who does not ask reamins a fool forever. Old Chinese saying
    Quote Originally Posted by worm4 View Post
    a .

  3. #3
    Registered User
    Join Date: Aug:2002
    Posts: 1,145
    Quote Originally Posted by Antonii View Post
    - . , , .
    excel .
    Find , .
    1 1 111111
    2 2 222222
    3 3 333333
    ............................
    Ann Bnn 9999

    , 4 , F4 INDEX(B1:Bnn;MATCH(E4;A1:Ann;0))

  4. #4
    Registered User
    Join Date: Jun:2010
    Location: .
    Posts: 55
    .
    Index Match .
    Vlookup , .

  5. #5
    Mire-x
    Join Date: Apr:2005
    Location: Sofia
    Posts: 763
    - VBA. , :

    http://stackoverflow.com/questions/8...-cell-in-excel

    :
    Code:
    =ConcatenateRange(A1:A1000)
    , :
    Code:
    Function ConcatenateRange(ByVal cell_range As range, _
                        Optional ByVal seperator As String) As String
    
    Dim cell As range
    Dim newString As String
    Dim cellArray As Variant
    Dim i As Long, j As Long
    
    cellArray = cell_range.Value
    
    For i = 1 To UBound(cellArray, 1)
        For j = 1 To UBound(cellArray, 2)
            If Len(cellArray(i, j)) <> 0 Then
                newString = newString & (seperator & cellArray(i, j))
            End If
        Next
    Next
    
    If Len(newString) <> 0 Then
        newString = Right$(newString, (Len(newString) - Len(seperator)))
    End If
    
    ConcatenateRange = newString
    
    End Function
    VBA Excel, ( WS Teleshop ):
    http://www.dummies.com/software/micr...cel-functions/
    (10b) || !(10b)

  6. #6
    Registered User
    Join Date: Jun:2010
    Location: .
    Posts: 55
    , Vlookup .
    .
    , . .

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Copyright © 1999-2011 . .
iskamPC.com | mobility.BG | Bloody's Techblog | | 3D Vision Blog |