Excel Formulas

Questions related specifically to the use of Excel formulas.

    1. Match Values on two worksheets by matching names 2

      • Static Electric
    2. Replies
      2
      Views
      693
      2
    3. Static Electric

    1. Count only first occurrence of criteria 3

      • Gaius
    2. Replies
      3
      Views
      740
      3
    3. Oeldere

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

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

    1. Time Sheet Formula 5

      • scarlett_b
    2. Replies
      5
      Views
      918
      5
    3. scarlett_b

    1. Incrementing multiple values in a cell 3

      • Facter
    2. Replies
      3
      Views
      736
      3
    3. crushdrinker06

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

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

    1. Executing a formula based on an IF statement 1

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

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

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

    1. compile error expected variable or procedure not module 2

      • abdiwahab
    2. Replies
      2
      Views
      2.8k
      2
    3. royUK

    1. Calculate average for specified numbers from a column 4

      • Mike91
    2. Replies
      4
      Views
      936
      4
    3. S O

    1. Counting numbers that appear in succession over different columns 2

      • MrCantaloupe
    2. Replies
      2
      Views
      619
      2
    3. FlameRetired

    1. Combine if statement with 3 different return 6

      • JianHan
    2. Replies
      6
      Views
      979
      6
    3. S O

    1. Align several columns into 1 columns 3

      • Kel13
    2. Replies
      3
      Views
      855
      3
    3. FlameRetired

    1. Count the values by ignoring cells which contain NA 2

      • ravs_1006
    2. Replies
      2
      Views
      787
      2
    3. crushdrinker06

    1. Join Excel tables 3

      • Kel13
    2. Replies
      3
      Views
      777
      3
    3. crushdrinker06

    1. Sheet reference based on another cell's value 2

      • Infomage
    2. Replies
      2
      Views
      687
      2
    3. Infomage

    1. Increment Alphanumeric cell values based on a range of alphanumeric cell values 3

      • aijazamg
    2. Replies
      3
      Views
      947
      3
    3. AliGW

    1. Convert decimal to text fraction 3

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

    1. Find all data using one criteria 1

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

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

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

Display Options