Posts by Ingo_Ingo

    Hi,


    Why you need the 4[SIZE=10px]th[/SIZE] ComboBox? Here is a simple cell in which it will appear - regardless of the previous selections, of the 3 ComboBox - Red, Yellow or Green.
    Then, you need a solution with formula or code VBA?

    Hi,


    The VBA code work well.
    VLOOKUP don't find ddd, fff and zzz and show error.


    Change in your code this line:


    .FormulaR1C1 = "=VLOOKUP(RC[-1], ACTION!R2C1:R200C5,5,FALSE)"


    with this


    .FormulaR1C1 = "=IFERROR(VLOOKUP(RC[-1], ACTION!R2C1:R200C5,5,FALSE),"""")"


    but it depends on the excel version.

    Good evening,


    On the 2nd row starting from B2 I have date (01.02.2018, 02.02.2018 .... 28.02.2018)
    I need a formula that writes the number 8 in every cell in row 3, starting with C3, and leaving empty the cells that on the 2nd are Saturday and Sunday plus the holidays that are in the DD column (say DD2: DD16) .
    The formula will be written in C3 and drawn to the right by the end of the month.


    Thank you.

    Re: Sort Alphabets within cell


    Quote from apo;732357

    argghh.. is there no way to control the way it sorts lower case first?


    mikerickson UDF Function SortDelimited can do.


    Re: Sort Alphabets within cell


    Mike in first UDF is small mistake


    Op want AaBb and the code result is AabB.



    [TABLE="width: 296"]

    [tr]


    [TD="width: 64, bgcolor: transparent"]CBA[/TD]
    [TD="width: 64, bgcolor: transparent"]ABC[/TD]
    [TD="width: 138, bgcolor: transparent"]=SortString(A2)[/TD]
    [TD="width: 64, bgcolor: transparent"][/TD]
    [TD="width: 64, bgcolor: transparent"][/TD]

    [/tr]


    [tr]


    [TD="bgcolor: transparent"]KG[/TD]
    [TD="bgcolor: transparent"]GK[/TD]
    [TD="bgcolor: transparent"][/TD]
    [TD="bgcolor: transparent"][/TD]
    [TD="bgcolor: transparent"][/TD]

    [/tr]


    [tr]


    [TD="bgcolor: transparent"]DEFPO[/TD]
    [TD="bgcolor: transparent"]DEFOP[/TD]
    [TD="bgcolor: transparent"][/TD]
    [TD="bgcolor: transparent"][/TD]
    [TD="bgcolor: transparent"][/TD]

    [/tr]


    [tr]


    [TD="bgcolor: transparent"]ABab[/TD]
    [TD="bgcolor: transparent"]AabB[/TD]
    [TD="bgcolor: transparent, align: left"]


    [/TD]
    [TD="class: xl66, bgcolor: transparent, colspan: 2"]How OP want[/TD]

    [/tr]


    [tr]


    [TD="bgcolor: transparent"]L[/TD]
    [TD="bgcolor: transparent"]L[/TD]
    [TD="bgcolor: transparent"][/TD]
    [TD="bgcolor: transparent"][/TD]
    [TD="bgcolor: transparent"][/TD]

    [/tr]


    [tr]


    [TD="bgcolor: transparent"][/TD]
    [TD="bgcolor: transparent"][/TD]
    [TD="bgcolor: transparent"][/TD]
    [TD="bgcolor: transparent"][/TD]
    [TD="bgcolor: transparent"][/TD]

    [/tr]


    [tr]


    [TD="bgcolor: transparent"][/TD]
    [TD="bgcolor: transparent"]ABC[/TD]
    [TD="bgcolor: transparent"]=SortString(A2;TRUE)[/TD]
    [TD="bgcolor: transparent"][/TD]
    [TD="bgcolor: transparent"][/TD]

    [/tr]


    [tr]


    [TD="bgcolor: transparent"][/TD]
    [TD="bgcolor: transparent"]GK[/TD]
    [TD="bgcolor: transparent"][/TD]
    [TD="bgcolor: transparent"][/TD]
    [TD="bgcolor: transparent"][/TD]

    [/tr]


    [tr]


    [TD="bgcolor: transparent"][/TD]
    [TD="bgcolor: transparent"]DEFOP[/TD]
    [TD="bgcolor: transparent"][/TD]
    [TD="bgcolor: transparent"][/TD]
    [TD="bgcolor: transparent"][/TD]

    [/tr]


    [tr]


    [TD="bgcolor: transparent"][/TD]
    [TD="bgcolor: transparent"]ABab[/TD]
    [TD="bgcolor: transparent"][/TD]
    [TD="bgcolor: transparent"][/TD]
    [TD="bgcolor: transparent"][/TD]

    [/tr]


    [tr]


    [TD="bgcolor: transparent"][/TD]
    [TD="bgcolor: transparent"]L[/TD]
    [TD="bgcolor: transparent"][/TD]
    [TD="bgcolor: transparent"][/TD]
    [TD="bgcolor: transparent"][/TD]

    [/tr]


    [tr]


    [TD="bgcolor: transparent"][/TD]
    [TD="bgcolor: transparent"][/TD]
    [TD="bgcolor: transparent"][/TD]
    [TD="bgcolor: transparent"][/TD]
    [TD="bgcolor: transparent"][/TD]

    [/tr]


    [/TABLE]

    Re: Populate a list based on a condition


    Well not that you asked at the beginning!
    In Assesment sheet, delete "Y" in column J, else formula will be complicate.
    What's the point to put "Y" to Harry if he then does not appear in sheet INTERVENTION ??

    Re: Populate a list based on a condition


    Hi,


    In sheet3 cell A5


    =IFERROR(INDEX(Sheet1!$A$5:$A$9,SMALL(IF(FREQUENCY(IF(Sheet1!$B$5:$B$9="M",MATCH(Sheet1!$A$5:$A$9,Sheet1!$A$5:$A$9,0)),ROW(Sheet1!$A$5:$A$9)-ROW(Sheet1!$A$5)+1),ROW(Sheet1!$A$5:$A$9)-ROW(Sheet1!$A$5)+1),ROWS(Sheet3!$A$4:A4))),"")


    and drag down


    and in sheet3 cell B5


    =VLOOKUP(A5,Sheet2!$A$5:$B$9,2,0)


    and drag down.