Posts by Ingo_Ingo

    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.

    Re: VBA Excel Advanced Filter


    Quote from Binning;727257

    [INDENT].... i think you've got the comma and the decimal mixed up.[/INDENT]


    39,640.86 is correct. 39.640,86 is not. excel will recognise the first number as a number, but the second it will identify as text.


    Binning


    You're wrong!
    In Europe decimal symbol is "," not "." and yes that number is: 39 thousand 6 hundred 40 euro and 86 cents.


    saya
    Excel sees that number as text. Where are those numbers? by copy paste? from another program?

    Re: unique values from multiple arrays


    Hallo XOR LX


    OP wants to list only numbers that are unique in both columns.
    Example: number 1 will not be listed as is found in the first column and the second column. Number 2 will be listed as it is only once in both columns.
    Number 10 will not be listed, as is found 2 times in the first column etc ...