Excel Formulas

Questions related specifically to the use of Excel formulas.

Mark All as Read

    2. - Excel match record from different position of row

      • phooirv
    3. Replies
      0
      Views
      148

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

      • paulbiddis
    3. Replies
      6
      Views
      1.1k
      6

    4. rory

    2. "tilde" in vlookup formula 13

      • Anri
      • Anri
    3. Replies
      13
      Views
      3.6k
      13

    4. Carim

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

      • N7AS
      • N7AS
    3. Replies
      2
      Views
      505
      2

    4. N7AS

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

      • AcctgController
    3. Replies
      19
      Views
      1.7k
      19

    4. George-1947

    2. #VALUE result whenever I use the Age Today formula 1

      • vinceymarko
    3. Replies
      1
      Views
      219
      1

    4. royUK

    2. 2 groups conditional formating 4

      • kennethbrandon
    3. Replies
      4
      Views
      982
      4

    4. kennethbrandon

    2. 3 Random Values from a list skipping blanks 2

      • wrigst
    3. Replies
      2
      Views
      1.7k
      2

    4. wrigst

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

      • legin52
    3. Replies
      0
      Views
      227

    2. A quicker way than INDEX to count unique values in a list 3

      • tac_79
    3. Replies
      3
      Views
      710
      3

    4. Carim

    2. Accrual formula 9

      • KEW115
    3. Replies
      9
      Views
      460
      9

    4. KEW115

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

      • Trev81
    3. Replies
      3
      Views
      1.1k
      3

    4. Trev81

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

      • TheTallOne
    3. Replies
      2
      Views
      505
      2

    4. Fluff13

    2. Add a calculated field to a pivot table 1

      • cobber1418
    3. Replies
      1
      Views
      501
      1

    4. alansidman

    2. Add a trend arrow to dashboard 1

      • shanethompson
    3. Replies
      1
      Views
      1.6k
      1

    4. AAE

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

      • wittonline
    3. Replies
      3
      Views
      636
      3

    4. wittonline

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

      • rnomis
    3. Replies
      1
      Views
      802
      1

    4. crushdrinker06

    2. Add Customize Spacing in a cell text value 1

      • luzmen
    3. Replies
      1
      Views
      421
      1

    4. Carim

    2. Add leading 0 only after letters 3

      • backgroundbook
    3. Replies
      3
      Views
      786
      3

    4. Carim

    2. Add Rounding to an Existing Formula 5

      • JubberB
    3. Replies
      5
      Views
      1.5k
      5

    4. NBVC

Label

Display Options