Excel Formulas

Questions related specifically to the use of Excel formulas.

    2. Formula to sum up same field values in different workbooks 4

      • lakshi
    3. Replies
      4
      Views
      323
      4

    4. lakshi

    2. Printing sheets based on data within a sheet. 1

      • VWRSue
    3. Replies
      1
      Views
      169
      1

    4. dangelor

    2. Need Vlookup to find line items and automatically subtract 8

      • massegirl21
    3. Replies
      8
      Views
      569
      8

    4. royUK

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

      • jrdnoland
    3. Replies
      1
      Views
      258
      1

    4. jrdnoland

    2. Use last value in a column, increment it by 1 and start a new column with this value. If value>x, then start the count in this column, from 1 11

      • leema
    3. Replies
      11
      Views
      597
      11

    4. Fluff13

    2. Average data by date excluding the first value 5

      • EnginerdUNH
    3. Replies
      5
      Views
      423
      5

    4. EnginerdUNH

    2. Formula Required

      • ShoaibRajput1
    3. Replies
      0
      Views
      127

    2. Worsheet_change Multiple uses same sheet 21

      • LearningXL
    3. Replies
      21
      Views
      691
      21

    4. LearningXL

    2. get data contains big and small letter and number 3

      • alhagag
    3. Replies
      3
      Views
      365
      3

    4. dangelor

    2. Vlookup not working for two sheets in same workbook 1

      • lakshi
    3. Replies
      1
      Views
      335
      1

    4. lakshi

    2. Data Validation and Formula in the same cell 8

      • jpetraityte
    3. Replies
      8
      Views
      882
      8

    4. royUK

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

      • Dapante
    3. Replies
      4
      Views
      240
      4

    4. Dapante

    2. Extracting a string up to a specific word (exact match) 3

      • Twiceborn
    3. Replies
      3
      Views
      179
      3

    4. Fluff13

    2. Finding the Median for certain dates from a list of data 12

      • moyad612013
    3. Replies
      12
      Views
      760
      12

    4. NBVC

    2. Vertical lookup when the range changes. 8

      • JoDor
    3. Replies
      8
      Views
      473
      8

    4. JoDor

    2. formula - if cell contain specific text then return all values in the list 11

      • Gemma86
    3. Replies
      11
      Views
      536
      11

    4. Fluff13

    2. Matching blank cells in SUMIFs with multiple criteria 2

      • browncoat
    3. Replies
      2
      Views
      347
      2

    4. browncoat

    2. COUNTIFS on Table and Between Dates 3

      • dloc_26
    3. Replies
      3
      Views
      332
      3

    4. Fluff13

    2. Extract data fields from wrapped text cell 7

      • hugletank
    3. Replies
      7
      Views
      602
      7

    4. hugletank

    2. 3 Random Values from a list skipping blanks 2

      • wrigst
    3. Replies
      2
      Views
      279
      2

    4. wrigst

Display Options