Excel Formulas

Questions related specifically to the use of Excel formulas.

    1. Sum with criteria in a table 1

      • Mark UK
    2. Replies
      1
      Views
      126
      1
    3. CARACALLA

    1. COUNT AND SUM FUNCTION BY DIALY, WEEKLY AND MONTHLY 2

      • nmkhan3010
    2. Replies
      2
      Views
      149
      2
    3. nmkhan3010

    1. Need HELP with ARRAY Formula 11

      • cs566
    2. Replies
      11
      Views
      472
      11
    3. cs566

    1. Unable to perform picture lookup in excel 4

      • Srisreshtan
    2. Replies
      4
      Views
      385
      4
    3. Srisreshtan

    1. Custom searchable drop down list..... 8

      • nmkhan3010
    2. Replies
      8
      Views
      355
      8
    3. GlennUK

    1. Text extraction and searchable data validation list 4

      • nmkhan3010
    2. Replies
      4
      Views
      176
      4
    3. nmkhan3010

    1. Automate my excel sheet with formulas (need to update dialy, weekly, monthly) 2

      • nmkhan3010
    2. Replies
      2
      Views
      175
      2
    3. nmkhan3010

    1. Unable to perform the index and multiple match array function 4

      • Srisreshtan
    2. Replies
      4
      Views
      252
      4
    3. Fluff13

    1. OFFSET combined with COUNTA 3

      • Chrischris
    2. Replies
      3
      Views
      190
      3
    3. bosco_yip

    1. Random Group Assignment 1

      • Hijodeagua
    2. Replies
      1
      Views
      124
      1
    3. royUK

    1. Lengthy SumIFS formulae 3

      • DezB
    2. Replies
      3
      Views
      165
      3
    3. royUK

    1. Countif, finding unique or duplicate records in two different sheets, each containing just one column of numbers 1

      • etb
      • etb
    2. Replies
      1
      Views
      164
      1
    3. etb

    1. Count time selected by year of date 2

      • remco77a
    2. Replies
      2
      Views
      153
      2
    3. remco77a

    1. need VBA code to find unique values, create sheets and pste data 3

      • dkool
    2. Replies
      3
      Views
      143
      3
    3. royUK

    1. staff rotas 1

      • golepori
    2. Replies
      1
      Views
      161
      1
    3. mdenino

    1. Force Removal of spaces on both sides of any dash/hyphen in an entire column in Excel 2

      • Kenan_
    2. Replies
      2
      Views
      163
      2
    3. GlennUK

    1. Please help with If, Then statement 15

      • Bendfella
    2. Replies
      15
      Views
      304
      15
    3. royUK

    1. Separation Formula Required 2

      • ShoaibRajput1
    2. Replies
      2
      Views
      204
      2
    3. royUK

    1. Converting Text to Time 7

      • TBro
      • TBro
    2. Replies
      7
      Views
      247
      7
    3. royUK

    1. Finding the earliest date/time when all tests parameters meet their respective targets (pass) 2

      • alex_a
    2. Replies
      2
      Views
      183
      2
    3. alex_a

Display Options