Excel Formulas

Questions related specifically to the use of Excel formulas.

Mark All as Read

    2. COUNTA, SUMIF and Concatenate 1

      • El Gallo
    3. Replies
      1
      Views
      793
      1

    4. El Gallo

    2. Add a calculated field to a pivot table 1

      • cobber1418
    3. Replies
      1
      Views
      501
      1

    4. alansidman

    2. Apostrophe Issue with Character Count 1

      • RSquirrel
    3. Replies
      1
      Views
      489
      1

    4. Fluff13

    2. Count number of consecutive values after 3rd occurrence 1

      • MegOzam
    3. Replies
      1
      Views
      440
      1

    4. royUK

    2. Printing sheets based on data within a sheet. 1

      • VWRSue
    3. Replies
      1
      Views
      475
      1

    4. dangelor

    2. Formulas: If(AND( , OR(NOT(COUNTIF not working correctly 1

      • jrdnoland
    3. Replies
      1
      Views
      693
      1

    4. jrdnoland

    2. Vlookup not working for two sheets in same workbook 1

      • lakshi
    3. Replies
      1
      Views
      823
      1

    4. lakshi

    2. Increasing Cell Space on Interactive Calendar 1

      • Drizz22
    3. Replies
      1
      Views
      441
      1

    4. royUK

    2. Select Cell Multiplier by Name 1

      • tandykins
    3. Replies
      1
      Views
      511
      1

    4. Pecoflyer

    2. Retrieve data from last row / cell in Dynamic Range 1

      • WillAnt
    3. Replies
      1
      Views
      1.9k
      1

    4. royUK

    2. Last cell containing data in Dynamic Range 1

      • WillAnt
    3. Replies
      1
      Views
      594
      1

    4. royUK

    2. Dynamic Sheet Formula 1

      • stuartgb100
    3. Replies
      1
      Views
      595
      1

    4. alansidman

    2. Some basic formular help 1

      • Potholes
    3. Replies
      1
      Views
      437
      1

    4. alansidman

    2. Copy every nth row and Insert the copied value every nth row 1

      • anakin1982
    3. Replies
      1
      Views
      541
      1

    4. bosco_yip

    2. Quick help with an IF formula in excel not working on large dataset 1

      • healthguy
    3. Replies
      1
      Views
      475
      1

    4. royUK

    2. conversion of hours & Minutes to hours & hundredths 1

      • CaptianBill
    3. Replies
      1
      Views
      569
      1

    4. royUK

    2. Format a range depending on inputted values 1

      • D_88
      • D_88
    3. Replies
      1
      Views
      579
      1

    4. GlennUK

    2. Countif Formula inc Trim 1

      • Krayna
    3. Replies
      1
      Views
      1.8k
      1

    4. GlennUK

    2. Sum with criteria in a table 1

      • Mark UK
    3. Replies
      1
      Views
      383
      1

    4. CARACALLA

    2. Random Group Assignment 1

      • Hijodeagua
    3. Replies
      1
      Views
      613
      1

    4. royUK

Label

Display Options