Excel Formulas

Questions related specifically to the use of Excel formulas.

    1. - Excel match record from different position of row

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

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

    1. "tilde" in vlookup formula 13

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

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

      • N7AS
      • N7AS
    2. Replies
      2
      Views
      505
      2
    3. N7AS

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

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

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

      • vinceymarko
    2. Replies
      1
      Views
      219
      1
    3. royUK

    1. 2 groups conditional formating 4

      • kennethbrandon
    2. Replies
      4
      Views
      982
      4
    3. kennethbrandon

    1. 3 Random Values from a list skipping blanks 2

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

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

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

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

    1. Accrual formula 9

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

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

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

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

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

    1. Add a calculated field to a pivot table 1

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

    1. Add a trend arrow to dashboard 1

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

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

      • wittonline
    2. Replies
      3
      Views
      636
      3
    3. wittonline

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

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

    1. Add Customize Spacing in a cell text value 1

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

    1. Add leading 0 only after letters 3

      • backgroundbook
    2. Replies
      3
      Views
      786
      3
    3. Carim

    1. Add Rounding to an Existing Formula 5

      • JubberB
    2. Replies
      5
      Views
      1.5k
      5
    3. NBVC

Label

Display Options