Excel Formulas

Questions related specifically to the use of Excel formulas.

Mark All as Read

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

      • Daidin
    3. Replies
      2
      Views
      934
      2

    4. sktneer

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

      • ivorykeys87
    3. Replies
      2
      Views
      789
      2

    4. AliGW

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

      • johnreid7477
    3. Replies
      3
      Views
      1.1k
      3

    4. AliGW

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

      • merz
      • merz
    3. Replies
      1
      Views
      998
      1

    4. merz

    2. Convert Decimal To Text in Fraction format 1

      • JohnDrew
    3. Replies
      1
      Views
      927
      1

    4. rory

    2. Comparing VLOOKUP speeds versus straight calculations 2

      • MathemAddicts
    3. Replies
      2
      Views
      1.5k
      2

    4. MathemAddicts

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

      • M Edwards
    3. Replies
      2
      Views
      884
      2

    4. M Edwards

    2. Contiguous Weighted Average Excluding Zeroes 2

      • gc052
    3. Replies
      2
      Views
      968
      2

    4. gc052

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

      • sarah81
    3. Replies
      3
      Views
      963
      3

    4. NBVC

    2. Sum if with 2 conditions 1

      • eurano
    3. Replies
      1
      Views
      770
      1

    4. NBVC

    2. Excel formula err lookup 1

      • libin baby
    3. Replies
      1
      Views
      885
      1

    4. NBVC

    2. Sumproduct and mid function 1

      • eurano
    3. Replies
      1
      Views
      925
      1

    4. NBVC

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

      • yogeshtalks
    3. Replies
      8
      Views
      2.2k
      8

    4. NBVC

    2. VLOOKUP does not return the correct values 1

      • mmills@itt-tech
    3. Replies
      1
      Views
      994
      1

    4. crushdrinker06

    2. Help to determine top sales person 5

      • Hoowzer
    3. Replies
      5
      Views
      1.5k
      5

    4. Hoowzer

    2. INDEX MATCH with multiple lookup_arrays/references 12

      • B.W.B.
    3. Replies
      12
      Views
      2.7k
      12

    4. B.W.B.

    2. Calulate Hours based on individual daily rates 6

      • DezB
      • DezB
    3. Replies
      6
      Views
      1.8k
      6

    4. sktneer

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

      • Vonsteiner
    3. Replies
      1
      Views
      763
      1

    4. Vonsteiner

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

      • eurano
    3. Replies
      1
      Views
      930
      1

    4. crushdrinker06

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

      • cmbonner
    3. Replies
      3
      Views
      1.1k
      3

    4. skywriter

Label

Display Options