Results 1 to 13 of 13

Thread: Excel

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Registered User
    Join Date: Jan:2019
    Location: sofia
    Posts: 1

    Excel

    !

    , .

    :

    , , 10-15 .

    , .

    5 (, , , , ). - , , . , ( ) (. ), "" (, , ., , )?

    , , , . . .

    drop down data validation, 1 , .

    !

  2. #2
    Banned
    Join Date: Aug:2006
    Location: Varna
    Posts: 869
    (. ), . .

  3. #3
    The point of no return ifch0's Avatar
    Join Date: Jun:2007
    Location:
    Posts: 3,678
    ?

    - ? .. , , ...? ?

    - . , - Data Validation -> Allow: "List" -> Source: .

    , , - VLOOKUP, Concatenate ( , "CHAR(10)" " " , ).
    , , , .
    : ( ) - (); (..) - (..).
    -----! , ...

  4. #4
    Registered User SFisher's Avatar
    Join Date: Nov:2007
    Location:
    Posts: 1,482
    .
    14000 -. / 80 , .. -. . - 80 - 1000 ., 81 - 1100 .
    .
    MSI B450 Tomahawk | AMD Ryzen 7 5700X & Arctic Liquid Freezer II 280 | Kingston FURY Beast 2x16GB | EVGA RTX 3060 Ti XC GAMING | WD SN850 1TB | Seasonic Focus GX-850 | be quiet! Pure Base 500 | LG 27GL850 | Edifier R1800TIII

  5. #5
    Banned all's Avatar
    Join Date: Feb:2003
    Location: Sofia
    Posts: 6,980
    , . - C.
    1. Data/Sort C. - D TEXT ( =Text(C5,"0") ). -. LEFT ( =LEFT(D5,2) ) 2 -. , . Data Subtotal. - Use function "count". add subtotal to - E. summary below results. . .
    2. , - , - . Data/Filter. Number Filters/between. 8000000000 8099999999. - 80- . , .
    Last edited by all; 14th August 2019 at 12:03.

  6. #6
    Registered User
    Join Date: Apr:2003
    Location:
    Posts: 2,762
    :

    LEFT, LEFTB functions
    Description
    LEFT returns the first character or characters in a text string, based on the number of characters you specify.

    Count ...
    Last edited by rrado; 14th August 2019 at 13:57.

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 |