Excel Formulas

Questions related specifically to the use of Excel formulas.

    1. Count of unique name and date of birth matches 6

      • QAM
      • QAM
    2. Replies
      6
      Views
      1.3k
      6
    3. QAM

    1. move cell values in Description from colums onto the same row based on a key 2

      • Daidin
    2. Replies
      2
      Views
      792
      2
    3. sktneer

    1. Tips on getting around length limits for formulas? 2

      • ivorykeys87
    2. Replies
      2
      Views
      664
      2
    3. AliGW

    1. Auto Number +1 from text, if duplicate text not increase 3

      • johnreid7477
    2. Replies
      3
      Views
      936
      3
    3. AliGW

    1. Use Hlookup to find then sum column within specific dates 1

      • merz
      • merz
    2. Replies
      1
      Views
      803
      1
    3. merz

    1. Convert Decimal To Text in Fraction format 1

      • JohnDrew
    2. Replies
      1
      Views
      782
      1
    3. rory

    1. Comparing VLOOKUP speeds versus straight calculations 2

      • MathemAddicts
    2. Replies
      2
      Views
      1.3k
      2
    3. MathemAddicts

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

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

    1. Contiguous Weighted Average Excluding Zeroes 2

      • gc052
    2. Replies
      2
      Views
      806
      2
    3. gc052

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

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

    1. Sum if with 2 conditions 1

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

    1. Excel formula err lookup 1

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

    1. Sumproduct and mid function 1

      • eurano
    2. Replies
      1
      Views
      755
      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
      850
      1
    3. crushdrinker06

    1. Help to determine top sales person 5

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

    1. INDEX MATCH with multiple lookup_arrays/references 12

      • B.W.B.
    2. Replies
      12
      Views
      2.2k
      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
      656
      1
    3. Vonsteiner

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

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

Display Options