Excel Formulas

Questions related specifically to the use of Excel formulas.

    2. Excel Concatenating for a Fixed Position Text file

      • slick225
    3. Replies
      0
      Views
      141

    2. SUMPRODUCT on 1 column and criteria on another columns

      • richardd8x
    3. Replies
      0
      Views
      115

    2. Hacking cross workbook references, how to connect local references

      • MDBJ
      • MDBJ
    3. Replies
      0
      Views
      88

    2. Pull Most Recent Date in data set with recurrent entries

      • lawsonrw
    3. Replies
      0
      Views
      185

    2. automating a table to feed into a chart

      • hightester
    3. Replies
      0
      Views
      121

    2. Copy-paste-values from a formula results in an apostrophe

      • arrkwill
    3. Replies
      0
      Views
      189

    2. Variable to excel formula

      • NewbieError
    3. Replies
      0
      Views
      120

    2. Deleted

      • jl2509
    3. Replies
      0
      Views
      95

    2. Dragging down a formula based on ranges

      • 1003064
    3. Replies
      0
      Views
      95

    2. Index & Match on Multiple Criteria

      • HelenZav
    3. Replies
      0
      Views
      120

    2. Looping through multiple data validation lists

      • waimea
    3. Replies
      0
      Views
      220

    2. A math calc from different sources with neat blank cells

      • legin52
    3. Replies
      0
      Views
      103

    2. Countif, Index, Match Indirect

      • Kumar Chandra
    3. Replies
      0
      Views
      117

    2. Create multiple formulas for one cell to top 5 a summed range of values

      • modernpsyche
    3. Replies
      0
      Views
      99

    2. Pairs of numbers last out by date

      • 1legin
    3. Replies
      0
      Views
      109

    2. Matching Text as lookup

      • kramer100
    3. Replies
      0
      Views
      89

    2. Matching Text and Transposing

      • kramer100
    3. Replies
      0
      Views
      101

    2. Conditional Formating. Copy across a row

      • Stephen Bennett
    3. Replies
      0
      Views
      116

    2. Copy/create new list if value in column is partial match with criteria

      • unknown_brother
    3. Replies
      0
      Views
      114

    2. Data Validation-Multiple Criteria

      • KEG
      • KEG
    3. Replies
      0
      Views
      94

Display Options