Excel Formulas

Questions related specifically to the use of Excel formulas.

    2. Searching on multiples dates. 7

      • Granier22
    3. Replies
      7
      Views
      253
      7

    4. royUK

    2. Sum with criteria in a table 1

      • Mark UK
    3. Replies
      1
      Views
      106
      1

    4. CARACALLA

    2. Custom searchable drop down list..... 8

      • nmkhan3010
    3. Replies
      8
      Views
      270
      8

    4. GlennUK

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

      • nmkhan3010
    3. Replies
      2
      Views
      113
      2

    4. nmkhan3010

    2. Unable to perform picture lookup in excel 4

      • Srisreshtan
    3. Replies
      4
      Views
      347
      4

    4. Srisreshtan

    2. Text extraction and searchable data validation list 4

      • nmkhan3010
    3. Replies
      4
      Views
      147
      4

    4. nmkhan3010

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

      • nmkhan3010
    3. Replies
      2
      Views
      137
      2

    4. nmkhan3010

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

      • Srisreshtan
    3. Replies
      4
      Views
      204
      4

    4. Fluff13

    2. OFFSET combined with COUNTA 3

      • Chrischris
    3. Replies
      3
      Views
      154
      3

    4. bosco_yip

    2. Random Group Assignment 1

      • Hijodeagua
    3. Replies
      1
      Views
      101
      1

    4. royUK

    2. Lengthy SumIFS formulae 3

      • DezB
    3. Replies
      3
      Views
      127
      3

    4. royUK

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

      • etb
      • etb
    3. Replies
      1
      Views
      149
      1

    4. etb

    2. Count time selected by year of date 2

      • remco77a
    3. Replies
      2
      Views
      120
      2

    4. remco77a

    2. staff rotas 1

      • golepori
    3. Replies
      1
      Views
      133
      1

    4. mdenino

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

      • dkool
    3. Replies
      3
      Views
      114
      3

    4. royUK

    2. Please help with If, Then statement 15

      • Bendfella
    3. Replies
      15
      Views
      246
      15

    4. royUK

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

      • Kenan_
    3. Replies
      2
      Views
      141
      2

    4. GlennUK

    2. Add leading 0 only after letters 3

      • backgroundbook
    3. Replies
      3
      Views
      247
      3

    4. Carim

    2. How to create an excel formula that will average the 2 highest values that are separated by a 3 week difference in testing date 19

      • healthguy
    3. Replies
      19
      Views
      589
      19

    4. sobi_256

    2. Separation Formula Required 2

      • ShoaibRajput1
    3. Replies
      2
      Views
      174
      2

    4. royUK

Display Options