Excel Formulas

Questions related specifically to the use of Excel formulas.

    2. Formula not working when Worksheet is Protected 2

      • mrbuttons
    3. Replies
      2
      Views
      177
      2

    4. mrbuttons

    2. Creating dynamic sheet reference while retaining "cell progression", for lack of the correct term ;-) 5

      • DerNuB
    3. Replies
      5
      Views
      211
      5

    4. Carim

    2. Display data from one tab as merged cells on another tab of workbook 12

      • ajrilo1
    3. Replies
      12
      Views
      662
      12

    4. ajrilo1

    2. Match and extract values on different columns 3

      • glenhmalefe2ds
    3. Replies
      3
      Views
      289
      3

    4. S O

    2. Drop down boxes and Pivot Tables 1

      • kramer100
    3. Replies
      1
      Views
      150
      1

    4. royUK

    2. Calculate ONLY if before the 10th day of month 7

      • Mirinjawbro
    3. Replies
      7
      Views
      298
      7

    4. Mirinjawbro

    2. Multiple sets of data in single cell 5

      • ajrilo1
    3. Replies
      5
      Views
      268
      5

    4. royUK

    2. Array Formula Value Error 7

      • Excel Noob
    3. Replies
      7
      Views
      354
      7

    4. Carim

    2. Modifying a formula 2

      • ajrilo1
    3. Replies
      2
      Views
      202
      2

    4. ajrilo1

    2. Match one cell value with another then extract row data 3

      • Smudge.Smith
    3. Replies
      3
      Views
      187
      3

    4. Carim

    2. Extract text from a string of text based on the range defined 13

      • brijeshkeni
    3. Replies
      13
      Views
      448
      13

    4. Carim

    2. Cell Value Fill Based on Color 11

      • dan_jordan84
    3. Replies
      11
      Views
      638
      11

    4. Carim

    2. 'tricking' excel to recognise a table header outside of the table 6

      • paulbiddis
    3. Replies
      6
      Views
      532
      6

    4. rory

    2. CountIFS in same row problem 2

      • jbanks
    3. Replies
      2
      Views
      399
      2

    4. rory

    2. FILTER and UNIQUE - dependent dropdown lists... 19

      • paulbiddis
    3. Replies
      19
      Views
      729
      19

    4. Carim

    2. Formula for calculating totals for different months in a list as a percentage? 7

      • Smudge.Smith
    3. Replies
      7
      Views
      270
      7

    4. Carim

    2. calculate average of dates 3

      • NormanW
    3. Replies
      3
      Views
      431
      3

    4. p45cal

    2. EXCEL FORMULA 9

      • beealf
    3. Replies
      9
      Views
      584
      9

    4. Carim

    2. INDIRECT function does not work when referencing to a dynamic list 10

      • paulbiddis
    3. Replies
      10
      Views
      447
      10

    4. Carim

    2. Nested IF ANDs 5

      • Sper434
    3. Replies
      5
      Views
      256
      5

    4. Carim

Display Options