Results 1 to 7 of 7

Thread: RQ: - ,

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Registered User EmoDinkov's Avatar
    Join Date: Sep:2008
    Location: KARNOBAT
    Posts: 786

    RQ: - ,

    ,

    .

    :


    H16 , 2 LG.

    , B3 LG (B3 ) D3 . IF, , , .

    Last edited by EmoDinkov; 25th May 2017 at 17:10.
    AMD Ryzen 5 3600 + Freezer 33 eSports ONE , AMD Radeon 5600 16GB DDR4-3600 T-Force Xcalibur RGB, MSI B450 Tomahawk MAX, Seasonic SS-520GB

  2. #2
    ɐ-əpoɔᴉu⋂ ɐ ə anrieff's Avatar
    Join Date: Apr:2004
    Location: Sofia
    Posts: 8,448
    , . D3 - . D3, . IF- .

    Visual Basic- , ,
    , . .
    "640K ught to be enough for anybody" - Bill Gates, 1981
    ::Machine specs::Fract::AGG::::Baileys::blog::YouTube channel

  3. #3
    Registered User EmoDinkov's Avatar
    Join Date: Sep:2008
    Location: KARNOBAT
    Posts: 786
    .... !

    "".

    ...
    AMD Ryzen 5 3600 + Freezer 33 eSports ONE , AMD Radeon 5600 16GB DDR4-3600 T-Force Xcalibur RGB, MSI B450 Tomahawk MAX, Seasonic SS-520GB

  4. #4

  5. #5
    Registered User CanceR's Avatar
    Join Date: Sep:2003
    Location:
    Posts: 721
    Quote Originally Posted by EmoDinkov View Post
    ,

    .

    :

    H16 , 2 LG.

    , B3 LG (B3 ) D3 . IF, , , .
    ( sheet Sheet2), , :
    3 , D3 [DataValidation >> Allow: List, Source: IF(B3="LG",LG_models,0) , LG_models named range >> Name Manager >> Name: LG_models, Refers to: =Sheet2!$F$16:$F$17] .. .
    !

  6. #6
    Registered User EmoDinkov's Avatar
    Join Date: Sep:2008
    Location: KARNOBAT
    Posts: 786
    Quote Originally Posted by CanceR View Post
    ( sheet Sheet2), , :
    3 , D3 [DataValidation >> Allow: List, Source: IF(B3="LG",LG_models,0) , LG_models named range >> Name Manager >> Name: LG_models, Refers to: =Sheet2!$F$16:$F$17] .. .
    ! !

    . ... Toshiba , LG, LG_models. Sorce-to If IF-?

    . .... IF-
    Last edited by EmoDinkov; 29th May 2017 at 18:05.
    AMD Ryzen 5 3600 + Freezer 33 eSports ONE , AMD Radeon 5600 16GB DDR4-3600 T-Force Xcalibur RGB, MSI B450 Tomahawk MAX, Seasonic SS-520GB

  7. #7
    Registered User
    Join Date: Aug:2009
    Location:
    Posts: 265
    (CSV - copy/paste A1, Paste options: Use Text Import Wizard: Delimited, Semicolon):
    Code:
    LG;Toshiba;Sony;;Brand;Sony;"=INDEX(TV;1;)"
    "=COUNTA(OFFSET(A$1;2;0;100))";"=COUNTA(OFFSET(B$1;2;0;100))";"=COUNTA(OFFSET(C$1;2;0;100))";;Model;;"=OFFSET(TV;2;MATCH(Brand;INDEX(TV;1;);0)-1;HLOOKUP(Brand;OFFSET(TV;0;0;2);2;0);1)"
    LG1;Toshiba1;Sony1;;;;
    LG2;Toshiba2;Sony2;;;;
    LG3;Toshiba3;Sony3;;;;
    ;Toshiba4;Sony4;;;;
    ;Toshiba5;Sony5;;;;
    ;Toshiba6;;;;;
    : TV: $A$1:$C$102 ( ), Brand: $F$6. G1:G2 Data Validation .
    Last edited by Avis; 30th May 2017 at 12:38.

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 |