Excel Formulas

Questions related specifically to the use of Excel formulas.

    1. How to use comma in a single worksheet to separate decimals. 7

      • onexc
    2. Replies
      7
      Views
      199
      7
    3. Carim

    1. Find common part number amongst various suppiers 1

      • mljohn
    2. Replies
      1
      Views
      122
      1
    3. alansidman

    1. INDEX MATCH across sheets 8

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

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

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

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

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

    1. Multiple Criteria Lookup while Working With Number 6

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

    1. Xlookup with duplicate values in return array 3

      • Aksaunder
    2. Replies
      3
      Views
      359
      3
    3. Carim

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

      • khanaran
    2. Replies
      41
      Views
      865
      41
    3. Carim

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

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

    1. Calculate seller price in Excel 8

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

    1. Dependent Drop Down List 9

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

    1. Drop Down List based on last used row 3

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

    1. Clear cell range without using VBA/Macro 4

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

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

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

    1. excel formula to lookup year and sum 3

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

    1. write formula in work sheet 7

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

    1. Formula not working when Worksheet is Protected 2

      • mrbuttons
    2. Replies
      2
      Views
      177
      2
    3. mrbuttons

    1. Conditional Format Exact Match 3

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

Display Options