Excel Formulas

Questions related specifically to the use of Excel formulas.

    2. Countifs date formula 14

      • cobber1418
    3. Replies
      14
      Views
      1.5k
      14

    4. royUK

    2. Highlight if Cell contains asterisk(*) 8

      • Anna Mary
    3. Replies
      8
      Views
      887
      8

    4. alansidman

    2. Search Specific Date from all Sheets with 2 criteria 2

      • ramkhans
    3. Replies
      2
      Views
      201
      2

    4. ramkhans

    2. Rotating Schedule 1

      • EXCELn00b18
    3. Replies
      1
      Views
      197
      1

    4. Pecoflyer

    2. Required a Formula to find out at least 3 times repeated values in a Single cell 8

      • khuramdon
    3. Replies
      8
      Views
      624
      8

    4. khuramdon

    2. Formula not working when Worksheet is Protected 2

      • mrbuttons
    3. Replies
      2
      Views
      366
      2

    4. mrbuttons

    2. Formatting Date/Time to a Specific Format 6

      • mrbuttons
    3. Replies
      6
      Views
      918
      6

    4. jerry_maguire

    2. Linking the value from a scroll bar / spin button to a formula 9

      • GradB
    3. Replies
      9
      Views
      1.1k
      9

    4. rory

    2. Grouping Time into specific Criteria/Group 3

      • mrbuttons
    3. Replies
      3
      Views
      655
      3

    4. rory

    2. Calculated Values on a Filtered Table 3

      • mrbuttons
    3. Replies
      3
      Views
      726
      3

    4. royUK

    2. Orders created in rolling 7 days period 9

      • cire_d
    3. Replies
      9
      Views
      993
      9

    4. royUK

    2. Search bar using FILTER formula 1

      • chester1993
    3. Replies
      1
      Views
      418
      1

    4. Fluff13

    2. CountIf Multiple Columns per Rows 9

      • mrbuttons
    3. Replies
      9
      Views
      1.3k
      9

    4. royUK

    2. Formula to sum up same field values in different workbooks 4

      • lakshi
    3. Replies
      4
      Views
      784
      4

    4. lakshi

    2. COUNTIFS on Table and Between Dates 3

      • dloc_26
    3. Replies
      3
      Views
      691
      3

    4. Fluff13

    2. move cell contents if the day is a "holiday" 2

      • IronMan82
    3. Replies
      2
      Views
      616
      2

    4. IronMan82

    2. Dynamic way to calculate the last 6 months average. 2

      • FaKest
    3. Replies
      2
      Views
      1.4k
      2

    4. royUK

    2. Data Query based on the drop down selection based on the dependent/independent drop down validation list 7

      • kumarma
    3. Replies
      7
      Views
      1.3k
      7

    4. GlennUK

    2. Countif Formula inc Trim 1

      • Krayna
    3. Replies
      1
      Views
      1.1k
      1

    4. GlennUK

    2. Searching on multiples dates. 7

      • Granier22
    3. Replies
      7
      Views
      1.1k
      7

    4. royUK

Display Options