Excel Formulas

Questions related specifically to the use of Excel formulas.

    1. Xlookup with duplicate values in return array 3

      • Aksaunder
    2. Replies
      3
      Views
      1.1k
      3
    3. Carim

    1. How to calculate variance and ratio total open and closed tickets? 1

      • Xani
      • Xani
    2. Replies
      1
      Views
      239
      1
    3. Carim

    1. Search Field, type keyword/s that searches through a column of data and returns all results 8

      • BlakeReuben
    2. Replies
      8
      Views
      394
      8
    3. Carim

    1. Moving to a specific cell based on another cell's data. 2

      • VWRSue
    2. Replies
      2
      Views
      302
      2
    3. Carim

    1. Using dropdowns to copy cells from one worksheet to corresponding cells of another worksheet and add new rows if needed. 4

      • CNeedsHelp
    2. Replies
      4
      Views
      529
      4
    3. royUK

    1. Dependent Drop Down List 9

      • busybee_1_in
    2. Replies
      9
      Views
      613
      9
    3. Carim

    1. Drop Down List based on last used row 3

      • busybee_1_in
    2. Replies
      3
      Views
      269
      3
    3. royUK

    1. Clear cell range without using VBA/Macro 4

      • kmsafstrom
    2. Replies
      4
      Views
      352
      4
    3. Carim

    1. Returning the last row of text in a cell, minus the first few words 4

      • chad71
    2. Replies
      4
      Views
      355
      4
    3. Carim

    1. excel formula to lookup year and sum 3

      • dkool
    2. Replies
      3
      Views
      265
      3
    3. Carim

    1. write formula in work sheet 7

      • supriyamk
    2. Replies
      7
      Views
      418
      7
    3. Carim

    1. Conditional Format Exact Match 3

      • Sper434
    2. Replies
      3
      Views
      287
      3
    3. Carim

    1. Formula not working when Worksheet is Protected 2

      • mrbuttons
    2. Replies
      2
      Views
      270
      2
    3. mrbuttons

    1. Creating dynamic sheet reference while retaining "cell progression", for lack of the correct term ;-) 5

      • DerNuB
    2. Replies
      5
      Views
      312
      5
    3. Carim

    1. Display data from one tab as merged cells on another tab of workbook 12

      • ajrilo1
    2. Replies
      12
      Views
      869
      12
    3. ajrilo1

    1. Match and extract values on different columns 3

      • glenhmalefe2ds
    2. Replies
      3
      Views
      409
      3
    3. S O

    1. Drop down boxes and Pivot Tables 1

      • kramer100
    2. Replies
      1
      Views
      210
      1
    3. royUK

    1. Calculate ONLY if before the 10th day of month 7

      • Mirinjawbro
    2. Replies
      7
      Views
      413
      7
    3. Mirinjawbro

    1. Multiple sets of data in single cell 5

      • ajrilo1
    2. Replies
      5
      Views
      386
      5
    3. royUK

    1. Array Formula Value Error 7

      • Excel Noob
    2. Replies
      7
      Views
      534
      7
    3. Carim

Display Options