Excel Formulas

Questions related specifically to the use of Excel formulas.

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

      • nilaymohit
    2. Replies
      22
      Views
      3.4k
      22
    3. MandyRead

    1. Tier Pricing Help 3

      • gzat
      • gzat
    2. Replies
      3
      Views
      642
      3
    3. gzat

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

      • kumarma
    2. Replies
      7
      Views
      1.2k
      7
    3. GlennUK

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

      • Kenan_
    2. Replies
      2
      Views
      495
      2
    3. GlennUK

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

      • Srisreshtan
    2. Replies
      4
      Views
      901
      4
    3. Fluff13

    1. Unable to perform picture lookup in excel 4

      • Srisreshtan
    2. Replies
      4
      Views
      930
      4
    3. Srisreshtan

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

      • Dapante
    2. Replies
      4
      Views
      640
      4
    3. Dapante

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

      • jrdnoland
    2. Replies
      1
      Views
      534
      1
    3. jrdnoland

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

      • MegOzam
    2. Replies
      1
      Views
      333
      1
    3. royUK

    1. Add a calculated field to a pivot table 1

      • cobber1418
    2. Replies
      1
      Views
      393
      1
    3. alansidman

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

      • jdwart
    2. Replies
      4
      Views
      603
      4
    3. jdwart

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

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

    1. Dependent Drop Down List 9

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

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

      • cobber1418
    2. Replies
      4
      Views
      719
      4
    3. cobber1418

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

      • cobber1418
    2. Replies
      5
      Views
      285
      5
    3. royUK

    1. Transfer data from one sheet to another automatically 3

      • Santoshi Para
    2. Replies
      3
      Views
      197
      3
    3. royUK

    1. 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
    2. Replies
      6
      Views
      424
      6
    3. dijoy

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

      • PrasadK
    2. Replies
      4
      Views
      226
      4
    3. bosco_yip

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

      • dkool
    2. Replies
      1
      Views
      94
      1
    3. royUK

Display Options