Excel Formulas

Questions related specifically to the use of Excel formulas.

    1. Sumproduct and mid function 1

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

    1. VLOOKUP does not return the correct values 1

    2. Replies
      1
      Views
      929
      1
    3. crushdrinker06

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

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

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

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

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

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

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

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

    1. Find all data using one criteria 1

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

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

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

    1. Executing a formula based on an IF statement 1

      • corcelle
    2. Replies
      1
      Views
      706
      1
    3. skywriter

    1. Combining <= and >= in same formula for time calculation 1

      • AussieNat
    2. Replies
      1
      Views
      712
      1
    3. crushdrinker06

    1. Employee Breakdown By Half Hour On Rotating 6 Week Schedule (Includes Training Day) 1

      • AFerg85
    2. Replies
      1
      Views
      724
      1
    3. MrRedli

    1. merge cell invoice no auto increment frormulla is not working 1

      • suresh45
    2. Replies
      1
      Views
      727
      1
    3. cytop

    1. Adding a range of cells based on addressing from a match 1

      • oddcarout
    2. Replies
      1
      Views
      620
      1
    3. skywriter

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

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

    1. Prevent Duplicate in Drop Down List 1

      • kapil.raj1985
    2. Replies
      1
      Views
      1.6k
      1
    3. pike

    1. Multiplying a number betwee ranges in an IF statement 1

      • MichelleY16
    2. Replies
      1
      Views
      805
      1
    3. NBVC

    1. Cell Reference and sorting 1

      • dtp81390
    2. Replies
      1
      Views
      737
      1
    3. crushdrinker06

    1. Multiple Drop Downs dependent on the previous 1

      • rklafka
    2. Replies
      1
      Views
      725
      1
    3. crushdrinker06

    1. Vlookup issues, if no is data found 1

      • jest3r
    2. Replies
      1
      Views
      1.1k
      1
    3. AliGW

    1. adding dynamic range to get rid of blanks 1

      • chubbychub
    2. Replies
      1
      Views
      1k
      1
    3. pike

Label

Display Options