Excel Formulas

Questions related specifically to the use of Excel formulas.

    1. Counting the frequency of a specific number on a specific day 2

      • M Edwards
    2. Replies
      2
      Views
      555
      2
    3. M Edwards

    1. Contiguous Weighted Average Excluding Zeroes 2

      • gc052
    2. Replies
      2
      Views
      633
      2
    3. gc052

    1. An array excel formula to increase the numebrs in the array bracket 3

      • sarah81
    2. Replies
      3
      Views
      597
      3
    3. NBVC

    1. Sum if with 2 conditions 1

      • eurano
    2. Replies
      1
      Views
      476
      1
    3. NBVC

    1. Excel formula err lookup 1

      • libin baby
    2. Replies
      1
      Views
      556
      1
    3. NBVC

    1. Sumproduct and mid function 1

      • eurano
    2. Replies
      1
      Views
      605
      1
    3. NBVC

    1. Using a value from a cell inside a formula 8

      • yogeshtalks
    2. Replies
      8
      Views
      1.3k
      8
    3. NBVC

    1. Help to determine top sales person 5

      • Hoowzer
    2. Replies
      5
      Views
      903
      5
    3. Hoowzer

    1. VLOOKUP does not return the correct values 1

    2. Replies
      1
      Views
      691
      1
    3. crushdrinker06

    1. Calulate Hours based on individual daily rates 6

      • DezB
      • DezB
    2. Replies
      6
      Views
      1.2k
      6
    3. sktneer

    1. SharePoint data not transferring to Table in Excel Completely 1

      • Vonsteiner
    2. Replies
      1
      Views
      511
      1
    3. Vonsteiner

    1. Index match with part of the text as condition 1

      • eurano
    2. Replies
      1
      Views
      621
      1
    3. crushdrinker06

    1. Not using blank cells in a IF & MIN statement 3

      • cmbonner
    2. Replies
      3
      Views
      714
      3
    3. skywriter

    1. Copy Array Formula in 2013 2

      • Spomone
    2. Replies
      2
      Views
      790
      2
    3. sktneer

    1. Dynamic Named range counting "" in data range 1

      • BScott05
    2. Replies
      1
      Views
      538
      1
    3. skywriter

    1. Put a formula in a text formatted cell. 1

      • reddale
    2. Replies
      1
      Views
      491
      1
    3. cytop

    1. Merge / Combine cell range into single cell with line break 2

      • Elusive
    2. Replies
      2
      Views
      746
      2
    3. cytop

    1. Payroll timesheet with complex payrate structure needing formula variation 1

      • AussieNat
    2. Replies
      1
      Views
      662
      1
    3. ansonsia

    1. Find all data using one criteria 1

      • hollyj
    2. Replies
      1
      Views
      513
      1
    3. skywriter

    1. Convert decimal to text fraction 3

      • JohnDrew
    2. Replies
      3
      Views
      846
      3
    3. JohnDrew

Display Options