Excel Formulas

Questions related specifically to the use of Excel formulas.

    2. Separate Letters and Numbers Formula 3

      • Gemma86
    3. Replies
      3
      Views
      219
      3

    4. Fluff13

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

      • leema
    3. Replies
      4
      Views
      287
      4

    4. royUK

    2. Formula Correction Required 4

      • ShoaibRajput1
    3. Replies
      4
      Views
      230
      4

    4. ShoaibRajput1

    2. Auto Add/Subtract 10

      • JJeffery99
    3. Replies
      10
      Views
      510
      10

    4. yongle

    2. Excel macro 97 - rotate picture 4

      • cvhelios
    3. Replies
      4
      Views
      237
      4

    4. rory

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

      • lakshi
    3. Replies
      4
      Views
      288
      4

    4. lakshi

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

      • VWRSue
    3. Replies
      1
      Views
      147
      1

    4. dangelor

    2. Data Validation and Formula in the same cell 8

      • jpetraityte
    3. Replies
      8
      Views
      817
      8

    4. royUK

    2. How to set prices over percentage

      • onexc
    3. Replies
      0
      Views
      152

    2. Hide used items in Data Validation dropdown list 4

      • Lukas1
    3. Replies
      4
      Views
      244
      4

    4. Lukas1

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

      • massegirl21
    3. Replies
      8
      Views
      511
      8

    4. royUK

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

      • jrdnoland
    3. Replies
      1
      Views
      233
      1

    4. jrdnoland

    2. Average data by date excluding the first value 5

      • EnginerdUNH
    3. Replies
      5
      Views
      371
      5

    4. EnginerdUNH

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

      • alhagag
    3. Replies
      3
      Views
      341
      3

    4. dangelor

    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
      528
      11

    4. Fluff13

    2. Worsheet_change Multiple uses same sheet 21

      • LearningXL
    3. Replies
      21
      Views
      580
      21

    4. LearningXL

    2. Formula Required

      • ShoaibRajput1
    3. Replies
      0
      Views
      118

    2. 3 Random Values from a list skipping blanks 2

      • wrigst
    3. Replies
      2
      Views
      248
      2

    4. wrigst

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

      • lakshi
    3. Replies
      1
      Views
      310
      1

    4. lakshi

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

      • Dapante
    3. Replies
      4
      Views
      219
      4

    4. Dapante

Display Options