Excel Formulas

Questions related specifically to the use of Excel formulas.

Mark All as Read

    2. Help including 1 more parameter

      • CAPSNOSPACE
    3. Replies
      0
      Views
      244

    2. Color code bar chart data bars based on a y- axis criteria dynamically 1

      • CapG
      • CapG
    3. Replies
      1
      Views
      766
      1

    4. GlennUK

    2. Formula to apply conditional formatting to highlight specific cells based the cell to the left

      • CapG
      • CapG
    3. Replies
      0
      Views
      446

    2. Sumif function not working.Returning zero 9

      • CapG
      • CapG
    3. Replies
      9
      Views
      1.1k
      9

    4. Fluff13

    2. VLOOKUP or something else 6

      • caper1965
    3. Replies
      6
      Views
      476
      6

    4. Carim

    2. Average Formula to omit 0 from being calculated 2

      • caper1965
    3. Replies
      2
      Views
      656
      2

    4. caper1965

    2. Returning 10 largest values when looking up in a list! 12

      • cambos444
    3. Replies
      12
      Views
      1.1k
      12

    4. alansidman

    2. Return Sum when date from 2 worksheet match and another criteria matches 4

      • callous1swife
    3. Replies
      4
      Views
      391
      4

    4. NBVC

    2. Averaging both positive and negative numbers 9

      • caldog
    3. Replies
      9
      Views
      1.1k
      9

    4. Carim

    2. Getting value of the latest date based on criteria 2

      • cakzprimz
    3. Replies
      2
      Views
      588
      2

    4. Carim

    2. If Formular calculating 2 items 3

      • byga85
    3. Replies
      3
      Views
      314
      3

    4. Carim

    2. VLookup on specific tab names 2

      • bwkisley
    3. Replies
      2
      Views
      665
      2

    4. bwkisley

    2. Link a Cell to a Picture?? 6

      • bwkisley
    3. Replies
      6
      Views
      1.1k
      6

    4. bwkisley

    2. Dependent Drop Down List 9

      • busybee_1_in
    3. Replies
      9
      Views
      1.3k
      9

    4. Carim

    2. Drop Down List based on last used row 3

      • busybee_1_in
    3. Replies
      3
      Views
      580
      3

    4. royUK

    2. countifs not counting date values when copied 1

      • bus9892
    3. Replies
      1
      Views
      231
      1

    4. bus9892

    2. Sum a value if its Date is within 90 days of each Month shown in second table 6

      • burdenpi
    3. Replies
      6
      Views
      800
      6

    4. Logit

    2. Identify highest score category within group 3

      • bunty_1244
    3. Replies
      3
      Views
      622
      3

    4. AliGW

    2. Dynamic Named range counting "" in data range 1

      • BScott05
    3. Replies
      1
      Views
      807
      1

    4. skywriter

    2. Extracting long format Month from Today() 1

      • Bryan021
    3. Replies
      1
      Views
      495
      1

    4. Infomage

Label

Display Options