Excel Formulas

Questions related specifically to the use of Excel formulas.

    1. Excel Concatenating for a Fixed Position Text file

      • slick225
    2. Replies
      0
      Views
      141
    1. SUMPRODUCT on 1 column and criteria on another columns

      • richardd8x
    2. Replies
      0
      Views
      115
    1. Hacking cross workbook references, how to connect local references

      • MDBJ
      • MDBJ
    2. Replies
      0
      Views
      88
    1. Pull Most Recent Date in data set with recurrent entries

      • lawsonrw
    2. Replies
      0
      Views
      185
    1. automating a table to feed into a chart

      • hightester
    2. Replies
      0
      Views
      121
    1. Copy-paste-values from a formula results in an apostrophe

      • arrkwill
    2. Replies
      0
      Views
      189
    1. Variable to excel formula

      • NewbieError
    2. Replies
      0
      Views
      120
    1. Deleted

      • jl2509
    2. Replies
      0
      Views
      95
    1. Dragging down a formula based on ranges

      • 1003064
    2. Replies
      0
      Views
      95
    1. Index & Match on Multiple Criteria

      • HelenZav
    2. Replies
      0
      Views
      120
    1. Looping through multiple data validation lists

      • waimea
    2. Replies
      0
      Views
      220
    1. A math calc from different sources with neat blank cells

      • legin52
    2. Replies
      0
      Views
      103
    1. Countif, Index, Match Indirect

      • Kumar Chandra
    2. Replies
      0
      Views
      117
    1. Create multiple formulas for one cell to top 5 a summed range of values

      • modernpsyche
    2. Replies
      0
      Views
      99
    1. Pairs of numbers last out by date

      • 1legin
    2. Replies
      0
      Views
      109
    1. Matching Text as lookup

      • kramer100
    2. Replies
      0
      Views
      89
    1. Matching Text and Transposing

      • kramer100
    2. Replies
      0
      Views
      101
    1. Conditional Formating. Copy across a row

      • Stephen Bennett
    2. Replies
      0
      Views
      116
    1. Copy/create new list if value in column is partial match with criteria

      • unknown_brother
    2. Replies
      0
      Views
      114
    1. Data Validation-Multiple Criteria

      • KEG
      • KEG
    2. Replies
      0
      Views
      94

Display Options