Excel Formulas

Questions related specifically to the use of Excel formulas.

    1. Searching on multiples dates. 7

      • Granier22
    2. Replies
      7
      Views
      253
      7
    3. royUK

    1. Sum with criteria in a table 1

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

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

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

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

      • nmkhan3010
    2. Replies
      2
      Views
      113
      2
    3. nmkhan3010

    1. Unable to perform picture lookup in excel 4

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

    1. Text extraction and searchable data validation list 4

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

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

      • nmkhan3010
    2. Replies
      2
      Views
      137
      2
    3. nmkhan3010

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

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

    1. OFFSET combined with COUNTA 3

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

    1. Random Group Assignment 1

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

    1. Lengthy SumIFS formulae 3

      • DezB
    2. Replies
      3
      Views
      127
      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
      149
      1
    3. etb

    1. Count time selected by year of date 2

      • remco77a
    2. Replies
      2
      Views
      120
      2
    3. remco77a

    1. staff rotas 1

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

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

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

    1. Please help with If, Then statement 15

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

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

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

    1. Add leading 0 only after letters 3

      • backgroundbook
    2. Replies
      3
      Views
      247
      3
    3. Carim

    1. 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
    2. Replies
      19
      Views
      589
      19
    3. sobi_256

    1. Separation Formula Required 2

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

Display Options