Excel Formulas

Questions related specifically to the use of Excel formulas.

    1. Matching Text as lookup

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

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

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

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

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

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

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

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

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

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

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

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

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

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

      • reborn537
    2. Replies
      0
      Views
      183
    1. Percentage Formula

      • ehutcher
    2. Replies
      0
      Views
      236
    1. sum based on 2 row criteria values.

      • reggieneo
    2. Replies
      0
      Views
      215
    1. Overlap by employee and date

      • chrisjdb
    2. Replies
      0
      Views
      182
    1. Sum average networkdays if cells aren't empty

      • Sp0ns
    2. Replies
      0
      Views
      228
    1. Need help in Excel

      • zey67
    2. Replies
      0
      Views
      215

Label

Display Options