Excel Formulas

Questions related specifically to the use of Excel formulas.

    1. Add leading 0 only after letters 3

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

    1. Use of OFFSET function to define X-Axis 3

      • babr1477
    2. Replies
      3
      Views
      372
      3
    3. Carim

    1. COUNTIFS with dynamic named ranges 14

      • Baber62
    2. Replies
      14
      Views
      2.9k
      14
    3. Baber62

    1. Need to find the right certificate to print? 2

      • B.W.B.
    2. Replies
      2
      Views
      536
      2
    3. B.W.B.

    1. Single Search formula for two or more conditions? 12

      • B.W.B.
    2. Replies
      12
      Views
      1.4k
      12
    3. AliGW

    1. FORECAST, in single cell, from 4 sheets? 10

      • B.W.B.
    2. Replies
      10
      Views
      1.9k
      10
    3. B.W.B.

    1. Find Max number value from text-number cell? 20

      • B.W.B.
    2. Replies
      20
      Views
      3.6k
      20
    3. XOR LX

    1. INDEX MATCH with multiple lookup_arrays/references 12

      • B.W.B.
    2. Replies
      12
      Views
      2.4k
      12
    3. B.W.B.

    1. Need To Alignment to The Right 1

      • azumi
    2. Replies
      1
      Views
      563
      1
    3. KjBox

    1. SUMIF with dates 2

      • aysam
    2. Replies
      2
      Views
      599
      2
    3. alansidman

    1. Vlookup function copying from different workbook and different sheet names.

      • Awesomun
    2. Replies
      0
      Views
      152
    1. Advanced lookup : Multiple criteria when looking up values in a table 2

      • awaqar
    2. Replies
      2
      Views
      405
      2
    3. awaqar

    1. last 5 records 5

      • avb85
    2. Replies
      5
      Views
      855
      5
    3. avb85

    1. Find a sum based on a date range and an aditional value 3

      • avb85
    2. Replies
      3
      Views
      612
      3
    3. Carim

    1. Nested IF Statement Alternative 8

      • aussiformula
    2. Replies
      8
      Views
      1.9k
      8
    3. aussiformula

    1. Countif or Array Formula 3

      • aussiformula
    2. Replies
      3
      Views
      1.4k
      3
    3. crushdrinker06

    1. If statement 2

      • aussiformula
    2. Replies
      2
      Views
      933
      2
    3. aussiformula

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

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

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

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

    1. Balance carried forward 2

      • Aussiebuilder
    2. Replies
      2
      Views
      1.7k
      2
    3. KjBox

Label

Display Options