Excel Formulas

Questions related specifically to the use of Excel formulas.

    1. generating named data based on values

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

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

      • James324
    2. Replies
      0
      Views
      153
    1. Index formula while working with different workbooks

      • onexc
    2. Replies
      0
      Views
      153
    1. index and match from several workbooks

      • Pikepro92
    2. Replies
      0
      Views
      155
    1. Dynamic linking with multiple spreadsheets

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

      • modernpsyche
    2. Replies
      0
      Views
      157
    1. Deleted

      • jl2509
    2. Replies
      0
      Views
      161
    1. Dates & Delay Highlighting

      • Baig1984
    2. Replies
      0
      Views
      162
    1. Return Column Header of Last Occurence of Specified Value

      • pmgibs
    2. Replies
      0
      Views
      163
    1. Overlap by employee and date

      • chrisjdb
    2. Replies
      0
      Views
      164
    1. Need help with a count formula that needs to eliminate duplicated records

      • AOrsborn
    2. Replies
      0
      Views
      164
    1. Needing help with formula to auto move text from one cell to another 2

      • Jingles3X
    2. Replies
      2
      Views
      164
      2
    3. KjBox

    1. Countif and indirect formula

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

      • MDBJ
      • MDBJ
    2. Replies
      0
      Views
      168
    1. Item sales price filtered by Item no. and date intervall

      • PatNAVNORWAY
    2. Replies
      0
      Views
      169
    1. Automatically make a list from filling in a variable in another sheet

      • tommeke
    2. Replies
      0
      Views
      169
    1. Counting Help 2

      • lightguy101
    2. Replies
      2
      Views
      171
      2
    3. royUK

    1. Converting from Google Sheets

      • KEG
      • KEG
    2. Replies
      0
      Views
      172
    1. Formula or Conditional Formatting? Cut and paste based on font color in another cell

      • sam15
    2. Replies
      0
      Views
      175

Label

Display Options