Excel Formulas

Questions related specifically to the use of Excel formulas.

    2. Select And Replicate A Named Range Based On A Cell Value 2

      • pbuffh
    3. Replies
      2
      Views
      442
      2

    4. pbuffh

    2. formula to compare a complete row to other row finding duplicates row 2

      • Sholtan
    3. Replies
      2
      Views
      480
      2

    4. AliGW

    2. Variable columns possible in Sumproduct (vlookup) formula 5

      • bob22
    3. Replies
      5
      Views
      1.7k
      5

    4. Carim

    2. Evaluation Several Conditions 7

      • ksstormhunter
    3. Replies
      7
      Views
      965
      7

    4. rory

    2. Highlight largest value cell in range based on other columns 15

      • paul789
    3. Replies
      15
      Views
      2.1k
      15

    4. AliGW

    2. Reg change of formula 8

      • Sholtan
    3. Replies
      8
      Views
      858
      8

    4. Sholtan

    2. SUMIF or SUMIFS 4

      • paul789
    3. Replies
      4
      Views
      875
      4

    4. alansidman

    2. Lookup a value 3

      • bogey69
    3. Replies
      3
      Views
      540
      3

    4. bogey69

    2. Circular Reference Erro 5

      • Melody00
    3. Replies
      5
      Views
      838
      5

    4. Melody00

    2. Index Small function to skip blank rows 8

      • dloc_26
    3. Replies
      8
      Views
      4.7k
      8

    4. Roger1955

    2. Randomly choose one instance of a text from multiple occurrences in a list or column 5

      • Crouty
    3. Replies
      5
      Views
      552
      5

    4. NBVC

    2. Roundup and IF Formula 1

      • jacjas
    3. Replies
      1
      Views
      472
      1

    4. NBVC

    2. If date and time formatted cell is 2 hours after different date and time formatted 3

      • Gemma86
    3. Replies
      3
      Views
      646
      3

    4. NBVC

    2. if and multiple criteria and if cell doesnt not contain specfic word 1

      • Gemma86
    3. Replies
      1
      Views
      448
      1

    4. NBVC

    2. Copy row of data if column 1 is a certain number 1

      • woodstock1984
    3. Replies
      1
      Views
      501
      1

    4. NBVC

    2. Concatenate formula did not return expected value 2

      • mekrog
    3. Replies
      2
      Views
      554
      2

    4. mekrog

    2. Show a particular letter/value if a specific cell is included with one of the lists 2

      • woodstock1984
    3. Replies
      2
      Views
      426
      2

    4. woodstock1984

    2. SUM with letters 1

      • crackwood01
    3. Replies
      1
      Views
      582
      1

    4. azumi

    2. Use COUNTIF on column that contains TRIM formula 3

      • paul789
    3. Replies
      3
      Views
      2.2k
      3

    4. AliGW

    2. Making an indirect countifs formula dynamic 3

      • Helz_Belz
    3. Replies
      3
      Views
      694
      3

    4. AliGW

Label

Display Options