Excel Formulas

Questions related specifically to the use of Excel formulas.

    1. INDEX MATCH across sheets 8

      • jbanks
    2. Replies
      8
      Views
      446
      8
    3. Carim

    1. Dependent dropdown lists with multiple words in the different sheets 17

      • onexc
    2. Replies
      17
      Views
      939
      17
    3. Carim

    1. Match a Word From A List Comma Separated in a Cell 9

      • onexc
    2. Replies
      9
      Views
      534
      9
    3. Carim

    1. Multiple Criteria Lookup while Working With Number 6

      • onexc
    2. Replies
      6
      Views
      397
      6
    3. Fluff13

    1. Xlookup with duplicate values in return array 3

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

    1. Match a value against a date and enter the matched value 41

      • khanaran
    2. Replies
      41
      Views
      1.7k
      41
    3. Carim

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

      • Xani
      • Xani
    2. Replies
      1
      Views
      248
      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
      406
      8
    3. Carim

    1. Calculate seller price in Excel 8

      • onexc
    2. Replies
      8
      Views
      451
      8
    3. onexc

    1. Dependent Drop Down List 9

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

    1. Drop Down List based on last used row 3

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

    1. Clear cell range without using VBA/Macro 4

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

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

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

    1. excel formula to lookup year and sum 3

      • dkool
    2. Replies
      3
      Views
      271
      3
    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
      537
      4
    3. royUK

    1. write formula in work sheet 7

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

    1. Formula not working when Worksheet is Protected 2

      • mrbuttons
    2. Replies
      2
      Views
      279
      2
    3. mrbuttons

    1. Conditional Format Exact Match 3

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

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

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

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

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

Display Options