Excel Formulas

Questions related specifically to the use of Excel formulas.

    1. Highlight if Cell contains asterisk(*) 8

      • Anna Mary
    2. Replies
      8
      Views
      921
      8
    3. alansidman

    1. Search bar using FILTER formula 1

      • chester1993
    2. Replies
      1
      Views
      427
      1
    3. Fluff13

    1. OFFSET combined with COUNTA 3

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

    1. Orders created in rolling 7 days period 9

      • cire_d
    2. Replies
      9
      Views
      1k
      9
    3. royUK

    1. Countifs date formula 14

      • cobber1418
    2. Replies
      14
      Views
      1.5k
      14
    3. royUK

    1. COUNTIFS on Table and Between Dates 3

      • dloc_26
    2. Replies
      3
      Views
      711
      3
    3. Fluff13

    1. Rotating Schedule 1

      • EXCELn00b18
    2. Replies
      1
      Views
      206
      1
    3. Pecoflyer

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

      • FaKest
    2. Replies
      2
      Views
      1.4k
      2
    3. royUK

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

      • GradB
    2. Replies
      9
      Views
      1.1k
      9
    3. rory

    1. Searching on multiples dates. 7

      • Granier22
    2. Replies
      7
      Views
      1.1k
      7
    3. royUK

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

      • IronMan82
    2. Replies
      2
      Views
      627
      2
    3. IronMan82

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

      • khuramdon
    2. Replies
      8
      Views
      647
      8
    3. khuramdon

    1. Countif Formula inc Trim 1

      • Krayna
    2. Replies
      1
      Views
      1.1k
      1
    3. GlennUK

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

      • kumarma
    2. Replies
      7
      Views
      1.3k
      7
    3. GlennUK

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

      • lakshi
    2. Replies
      4
      Views
      798
      4
    3. lakshi

    1. CountIf Multiple Columns per Rows 9

      • mrbuttons
    2. Replies
      9
      Views
      1.4k
      9
    3. royUK

    1. Calculated Values on a Filtered Table 3

      • mrbuttons
    2. Replies
      3
      Views
      735
      3
    3. royUK

    1. Grouping Time into specific Criteria/Group 3

      • mrbuttons
    2. Replies
      3
      Views
      667
      3
    3. rory

    1. Formatting Date/Time to a Specific Format 6

      • mrbuttons
    2. Replies
      6
      Views
      942
      6
    3. jerry_maguire

    1. Formula not working when Worksheet is Protected 2

      • mrbuttons
    2. Replies
      2
      Views
      376
      2
    3. mrbuttons

Display Options