Excel Formulas

Questions related specifically to the use of Excel formulas.

    1. Sumproduct and mid function 1

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

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

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

    1. VLOOKUP does not return the correct values 1

    2. Replies
      1
      Views
      836
      1
    3. crushdrinker06

    1. Help to determine top sales person 5

      • Hoowzer
    2. Replies
      5
      Views
      1.2k
      5
    3. Hoowzer

    1. INDEX MATCH with multiple lookup_arrays/references 12

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

    1. Calulate Hours based on individual daily rates 6

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

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

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

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

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

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

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

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

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

    1. Formulas using the "IF" function. 6

      • Pauli57
    2. Replies
      6
      Views
      1.2k
      6
    3. Pauli57

    1. Copy Array Formula in 2013 2

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

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

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

    1. Find all data using one criteria 1

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

    1. Convert decimal to text fraction 3

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

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

      • aijazamg
    2. Replies
      3
      Views
      1.1k
      3
    3. AliGW

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

      • Infomage
    2. Replies
      2
      Views
      788
      2
    3. Infomage

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

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

    1. Combine if statement with 3 different return 6

      • JianHan
    2. Replies
      6
      Views
      1.2k
      6
    3. S O

    1. compile error expected variable or procedure not module 2

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

Display Options