Excel Formulas

Questions related specifically to the use of Excel formulas.

Mark All as Read

    2. Find matching string and get string of data in offset cell from raw dataset 15

      • robystar
    3. Replies
      15
      Views
      813
      15

    4. Carim

    2. Please help with If, Then statement 15

      • Bendfella
    3. Replies
      15
      Views
      1.5k
      15

    4. royUK

    2. Getting #VALUE with SUMPRODUCT formula 15

      • HestiA
    3. Replies
      15
      Views
      1.8k
      15

    4. Carim

    2. Conditional Format Alternate Columns 15

      • jl2509
    3. Replies
      15
      Views
      1.3k
      15

    4. royUK

    2. Count ifs last 4 or 5 results 15

      • thomascrown
    3. Replies
      15
      Views
      1.8k
      15

    4. NBVC

    2. Convert time to a usable format in a formula 15

      • jl2509
    3. Replies
      15
      Views
      2k
      15

    4. Carim

    2. Highlight largest value cell in range based on other columns 15

      • paul789
    3. Replies
      15
      Views
      2.2k
      15

    4. AliGW

    2. select by data validation list to highlight the cells 15

      • sathishsusa
    3. Replies
      15
      Views
      2.3k
      15

    4. Joris Moerings

    2. Countifs date formula 14

      • cobber1418
    3. Replies
      14
      Views
      1.9k
      14

    4. royUK

    2. Freight Cost Calc. based on Transport and Toll Cost with some criteria 14

      • Foday
    3. Replies
      14
      Views
      1.4k
      14

    4. Carim

    2. Combining Monthly Fee Totals by month, year, and location with Annual Fee Increases 14

      • Retailmessiah
    3. Replies
      14
      Views
      1.5k
      14

    4. Carim

    2. How to automatically apply this formula? 14

      • MazExpress
    3. Replies
      14
      Views
      1.5k
      14

    4. royUK

    2. Help with formula that will sum number values within text in a cell range 14

      • scharlene
    3. Replies
      14
      Views
      1.8k
      14

    4. Carim

    2. Find underline and bold text with cells. 14

      • cya
      • cya
    3. Replies
      14
      Views
      5.2k
      14

    4. Carim

    2. Join data in 3 Columns to 1 column 14

      • jl2509
    3. Replies
      14
      Views
      1.8k
      14

    4. jl2509

    2. Spreading Amount based on Date Range 14

      • Neilplateau
    3. Replies
      14
      Views
      1.2k
      14

    4. AliGW

    2. Find matching unique numbers in any order or find duplicate numbers in any order 14

      • scratchmaster
    3. Replies
      14
      Views
      1.7k
      14

    4. deciog

    2. Count actual word in cell 14

      • jotoya
    3. Replies
      14
      Views
      1.9k
      14

    4. jotoya

    2. COUNTIFS with dynamic named ranges 14

      • Baber62
    3. Replies
      14
      Views
      3.1k
      14

    4. Baber62

    2. define range (C1:C24) with formula 14

      • andrej
    3. Replies
      14
      Views
      2k
      14

    4. AliGW

Label

Display Options