Excel Formulas

Questions related specifically to the use of Excel formulas.

    2. Excel formula or VBA code for extracting external file links 1

      • dkool
    3. Replies
      1
      Views
      111
      1

    4. royUK

    2. Transfer data from one sheet to another automatically 3

      • Santoshi Para
    3. Replies
      3
      Views
      216
      3

    4. royUK

    2. how to extract 10 digit mobile number within text or specialcharacter 4

      • PrasadK
    3. Replies
      4
      Views
      250
      4

    4. bosco_yip

    2. Countifs formula to only count 'Last month' 5

      • cobber1418
    3. Replies
      5
      Views
      303
      5

    4. royUK

    2. Count number of consecutive values after 3rd occurrence 1

      • MegOzam
    3. Replies
      1
      Views
      340
      1

    4. royUK

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

      • VWRSue
    3. Replies
      2
      Views
      378
      2

    4. Carim

    2. Add a calculated field to a pivot table 1

      • cobber1418
    3. Replies
      1
      Views
      403
      1

    4. alansidman

    2. Extract numbers after specific text in a text string with bracket for negative values and divide the number by 100 if letter 'c' associated with number 6

      • dijoy
    3. Replies
      6
      Views
      451
      6

    4. dijoy

    2. Force Removal of spaces on both sides of any dash/hyphen in an entire column in Excel 2

      • Kenan_
    3. Replies
      2
      Views
      510
      2

    4. GlennUK

    2. Formulas: If(AND( , OR(NOT(COUNTIF not working correctly 1

      • jrdnoland
    3. Replies
      1
      Views
      544
      1

    4. jrdnoland

    2. Excel: I want a list of dates to populate if the word fail is entered 4

      • jdwart
    3. Replies
      4
      Views
      630
      4

    4. jdwart

    2. Tier Pricing Help 3

      • gzat
      • gzat
    3. Replies
      3
      Views
      649
      3

    4. gzat

    2. The Excel links between 2 files are lost after sending them to a new PC. 4

      • Dapante
    3. Replies
      4
      Views
      659
      4

    4. Dapante

    2. Countifs formula using A:A or A2:A1000 4

      • cobber1418
    3. Replies
      4
      Views
      738
      4

    4. cobber1418

    2. Dependent Drop Down List 9

      • busybee_1_in
    3. Replies
      9
      Views
      806
      9

    4. Carim

    2. Unable to perform the index and multiple match array function 4

      • Srisreshtan
    3. Replies
      4
      Views
      918
      4

    4. Fluff13

    2. Unable to perform picture lookup in excel 4

      • Srisreshtan
    3. Replies
      4
      Views
      951
      4

    4. Srisreshtan

    2. Data Query based on the drop down selection based on the dependent/independent drop down validation list 7

      • kumarma
    3. Replies
      7
      Views
      1.2k
      7

    4. GlennUK

    2. I want Vlookup to return Formula and take cell reference from Target sheet. 22

      • nilaymohit
    3. Replies
      22
      Views
      3.5k
      22

    4. MandyRead

Display Options