Excel Formulas

Questions related specifically to the use of Excel formulas.

    1. Looping through multiple data validation lists

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

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

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

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

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

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

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

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

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

      • KEG
      • KEG
    2. Replies
      0
      Views
      79
    1. Return Column Header of Last Occurence of Specified Value

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

      • tommeke
    2. Replies
      0
      Views
      86
    1. Converting from Google Sheets

      • KEG
      • KEG
    2. Replies
      0
      Views
      87
    1. Teammates can’t match up in 3 consecutive days

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

      • James324
    2. Replies
      0
      Views
      73
    1. Conditional Formatting on Cells with Date and Time

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

      • Awesomun
    2. Replies
      0
      Views
      69
    1. hep with this code

      • LynChen
    2. Replies
      0
      Views
      384
    1. Convert a variable frequency square wave to a percentage

      • James125
    2. Replies
      0
      Views
      97
    1. Despatch model

      • reborn537
    2. Replies
      0
      Views
      99

Display Options