Excel Formulas

Questions related specifically to the use of Excel formulas.

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

      • lakshi
    2. Replies
      4
      Views
      323
      4
    3. lakshi

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

      • VWRSue
    2. Replies
      1
      Views
      169
      1
    3. dangelor

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

      • massegirl21
    2. Replies
      8
      Views
      569
      8
    3. royUK

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

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

    1. 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
    2. Replies
      11
      Views
      597
      11
    3. Fluff13

    1. Average data by date excluding the first value 5

      • EnginerdUNH
    2. Replies
      5
      Views
      423
      5
    3. EnginerdUNH

    1. Formula Required

      • ShoaibRajput1
    2. Replies
      0
      Views
      127
    1. Worsheet_change Multiple uses same sheet 21

      • LearningXL
    2. Replies
      21
      Views
      691
      21
    3. LearningXL

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

      • alhagag
    2. Replies
      3
      Views
      365
      3
    3. dangelor

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

      • lakshi
    2. Replies
      1
      Views
      335
      1
    3. lakshi

    1. Data Validation and Formula in the same cell 8

      • jpetraityte
    2. Replies
      8
      Views
      882
      8
    3. royUK

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

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

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

      • Twiceborn
    2. Replies
      3
      Views
      179
      3
    3. Fluff13

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

      • moyad612013
    2. Replies
      12
      Views
      760
      12
    3. NBVC

    1. Vertical lookup when the range changes. 8

      • JoDor
    2. Replies
      8
      Views
      473
      8
    3. JoDor

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

      • Gemma86
    2. Replies
      11
      Views
      536
      11
    3. Fluff13

    1. Matching blank cells in SUMIFs with multiple criteria 2

      • browncoat
    2. Replies
      2
      Views
      347
      2
    3. browncoat

    1. COUNTIFS on Table and Between Dates 3

      • dloc_26
    2. Replies
      3
      Views
      332
      3
    3. Fluff13

    1. Extract data fields from wrapped text cell 7

      • hugletank
    2. Replies
      7
      Views
      602
      7
    3. hugletank

    1. 3 Random Values from a list skipping blanks 2

      • wrigst
    2. Replies
      2
      Views
      279
      2
    3. wrigst

Display Options