Threads by alz1

    1. Title
    2. Replies
    3. Last Reply
    1. using INDIRECT to set structured table reference in formula and return COUNTIF result based on another column value 2

      • alz1
    2. Replies
      2
      Views
      471
      2
    3. alz1

    1. display latest date for specific value 2

      • alz1
    2. Replies
      2
      Views
      894
      2
    3. alz1

    1. combine lookup and count no of occurences of a string that relate to the lookup value 2

      • alz1
    2. Replies
      2
      Views
      1.1k
      2
    3. alz1

    1. Using nested IF statements for date calculations 4

      • alz1
    2. Replies
      4
      Views
      2k
      4
    3. alz1

    1. list common values across columns 2

      • alz1
    2. Replies
      2
      Views
      1.1k
      2
    3. alz1

    1. Apply a formula to a cell based on a lookup value 2

      • alz1
    2. Replies
      2
      Views
      1.2k
      2
    3. alz1

    1. apply different conditional formating to border based on value in cell above/below 6

      • alz1
    2. Replies
      6
      Views
      2.3k
      6
    3. alz1

    1. Inject formula into cell based on lookup value 4

      • alz1
    2. Replies
      4
      Views
      2.2k
      4
    3. alz1

    1. Use one conditional formatting rule to check for multiple values 2

      • alz1
    2. Replies
      2
      Views
      1.4k
      2
    3. alz1

    1. derive file extension from a path contained in a cell 3

      • alz1
    2. Replies
      3
      Views
      1.2k
      3
    3. cytop