Excel Formulas

Questions related specifically to the use of Excel formulas.

    1. Pairs of numbers last out by date

      • 1legin
    2. Replies
      0
      Views
      84
    1. How to fill missing enteries in column A, and add respective corresponding entries 1

      • JYousuf
    2. Replies
      1
      Views
      83
      1
    3. alansidman

    1. Teammates can’t match up in 3 consecutive days

      • Golfnut1
    2. Replies
      0
      Views
      81
    1. Overlap by employee and date

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

      • legin52
    2. Replies
      0
      Views
      80
    1. Matching Text and Transposing

      • kramer100
    2. Replies
      0
      Views
      80
    1. Data Validation-Multiple Criteria

      • KEG
      • KEG
    2. Replies
      0
      Views
      79
    1. Range Names from another Cell 1

      • sm789
    2. Replies
      1
      Views
      78
      1
    3. KjBox

    1. Hyperlink to Today's Date 2

      • MAID1812
    2. Replies
      2
      Views
      77
      2
    3. deciog

    1. Dragging down a formula based on ranges

      • 1003064
    2. Replies
      0
      Views
      76
    1. Finding y-axis value

      • husnafezaahmad
    2. Replies
      0
      Views
      75
    1. Dates & Delay Highlighting

      • Baig1984
    2. Replies
      0
      Views
      75
    1. Matching Text as lookup

      • kramer100
    2. Replies
      0
      Views
      74
    1. Return Column Header of Last Occurence of Specified Value

      • pmgibs
    2. Replies
      0
      Views
      74
    1. SUM but only the last instance / occurrence if there are duplicates

      • James324
    2. Replies
      0
      Views
      73
    1. sum based on 2 row criteria values.

      • reggieneo
    2. Replies
      0
      Views
      73
    1. VLookup on specific tab names 2

      • bwkisley
    2. Replies
      2
      Views
      71
      2
    3. bwkisley

    1. index and match from several workbooks

      • Pikepro92
    2. Replies
      0
      Views
      70
    1. Vlookup function copying from different workbook and different sheet names.

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

      • MDBJ
      • MDBJ
    2. Replies
      0
      Views
      68

Display Options