Excel Formulas

Questions related specifically to the use of Excel formulas.

    1. Separate Letters and Numbers Formula 3

      • Gemma86
    2. Replies
      3
      Views
      219
      3
    3. Fluff13

    1. Increment day count based on month (30/31 days) and incorporate leap years 4

      • leema
    2. Replies
      4
      Views
      287
      4
    3. royUK

    1. Formula Correction Required 4

      • ShoaibRajput1
    2. Replies
      4
      Views
      230
      4
    3. ShoaibRajput1

    1. Auto Add/Subtract 10

      • JJeffery99
    2. Replies
      10
      Views
      510
      10
    3. yongle

    1. Excel macro 97 - rotate picture 4

      • cvhelios
    2. Replies
      4
      Views
      237
      4
    3. rory

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

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

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

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

    1. Data Validation and Formula in the same cell 8

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

    1. How to set prices over percentage

      • onexc
    2. Replies
      0
      Views
      152
    1. Hide used items in Data Validation dropdown list 4

      • Lukas1
    2. Replies
      4
      Views
      244
      4
    3. Lukas1

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

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

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

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

    1. Average data by date excluding the first value 5

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

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

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

    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
      528
      11
    3. Fluff13

    1. Worsheet_change Multiple uses same sheet 21

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

    1. Formula Required

      • ShoaibRajput1
    2. Replies
      0
      Views
      118
    1. 3 Random Values from a list skipping blanks 2

      • wrigst
    2. Replies
      2
      Views
      248
      2
    3. wrigst

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

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

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

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

Display Options