Excel Formulas

Questions related specifically to the use of Excel formulas.

Important Notice


Please note that on 14th December 2023 users will experience an expected outage whilst we make upgrades to our network. We anticipate this process may take a couple of hours and so we apologise in advance for any inconvenience.

    1. - Excel match record from different position of row

      • phooirv
    2. Replies
      0
      Views
      167
    1. 'tricking' excel to recognise a table header outside of the table 6

      • paulbiddis
    2. Replies
      6
      Views
      1.3k
      6
    3. rory

    1. "tilde" in vlookup formula 13

      • Anri
      • Anri
    2. Replies
      13
      Views
      3.9k
      13
    3. Carim

    1. [Solved] Check Number for Assigning Time Excel 2007 4

      • Bikke
    2. Replies
      4
      Views
      253
      4
    3. Bikke

    1. [Solved] Find a number in another Tab, Excel 2007 4

      • Bikke
    2. Replies
      4
      Views
      231
      4
    3. Bikke

    1. [SOLVED] Help with Excel 2007 formula - Divide SUM of Cells 2

      • N7AS
      • N7AS
    2. Replies
      2
      Views
      548
      2
    3. N7AS

    1. [Solved] Merge data from three cells into one date cell, Excel 2007 4

      • Bikke
    2. Replies
      4
      Views
      224
      4
    3. Ingo_Ingo

    1. # of Orders that Shipped Out After the Order Date Excluding Duplicate Order #s 19

      • AcctgController
    2. Replies
      19
      Views
      2k
      19
    3. George-1947

    1. 2 groups conditional formating 4

      • kennethbrandon
    2. Replies
      4
      Views
      1.1k
      4
    3. kennethbrandon

    1. 3 Random Values from a list skipping blanks 2

      • wrigst
    2. Replies
      2
      Views
      2.1k
      2
    3. wrigst

    1. A math calc from different sources with neat blank cells

      • legin52
    2. Replies
      0
      Views
      264
    1. A quicker way than INDEX to count unique values in a list 3

      • tac_79
    2. Replies
      3
      Views
      775
      3
    3. Carim

    1. Accrual formula 9

      • KEW115
    2. Replies
      9
      Views
      629
      9
    3. KEW115

    1. Adapting a linear annual calendar from data used to generate monthly annual calendars 3

      • Trev81
    2. Replies
      3
      Views
      1.4k
      3
    3. Trev81

    1. Add 1 to cell when another cell equals $200 increments 2

      • TheTallOne
    2. Replies
      2
      Views
      549
      2
    3. Fluff13

    1. Add a calculated field to a pivot table 1

      • cobber1418
    2. Replies
      1
      Views
      550
      1
    3. alansidman

    1. Add a trend arrow to dashboard 1

      • shanethompson
    2. Replies
      1
      Views
      1.7k
      1
    3. AAE

    1. Add an additional IF statement with a qualifying column value to existing formulas 3

      • wittonline
    2. Replies
      3
      Views
      713
      3
    3. wittonline

    1. add another IF to an IF, AND, OR statement 1

      • rnomis
    2. Replies
      1
      Views
      882
      1
    3. crushdrinker06

    1. Add Customize Spacing in a cell text value 1

      • luzmen
    2. Replies
      1
      Views
      464
      1
    3. Carim

Label

Display Options