Excel Formulas

Questions related specifically to the use of Excel formulas.

Important Notice


Please note that on 14th December 2023 users will experience an expected outage whilst we make upgrades to our network. We anticipate this process may take a couple of hours and so we apologise in advance for any inconvenience.

Mark All as Read

    2. How can I move cells ? - VBA 9

      • karankmr189874
    3. Replies
      9
      Views
      482
      9

    4. Carim

    2. Excel Formula Sum of Minimum Values 10

      • GIRISHBISHT
    3. Replies
      10
      Views
      2.5k
      10

    4. pike

    2. Trying to pull specific data from sheet1 to other sheets if it meets criteria 10

      • blade671
    3. Replies
      10
      Views
      2.4k
      10

    4. blade671

    2. FORECAST, in single cell, from 4 sheets? 10

      • B.W.B.
    3. Replies
      10
      Views
      2.1k
      10

    4. B.W.B.

    2. Calculate overtime based on 8 hour day / 44 hour week 10

      • Excel Noob
    3. Replies
      10
      Views
      5.8k
      10

    4. Infomage

    2. Calculating the total commission value from a sliding scale 10

      • 3008300363
    3. Replies
      10
      Views
      1.8k
      10

    4. KjBox

    2. Minimum Date if cell contains part of another cell value 10

      • dRaz
      • dRaz
    3. Replies
      10
      Views
      1.9k
      10

    4. AliGW

    2. AverageIf #DIV/0! error 10

      • Murph0625
    3. Replies
      10
      Views
      3.9k
      10

    4. NBVC

    2. Counting cells filling multiple criteria 10

      • Zwifter52
    3. Replies
      10
      Views
      1.3k
      10

    4. NBVC

    2. Index/Match Formula Disappears after Ctrl-Shift-Enter 10

      • OldFella
    3. Replies
      10
      Views
      2.9k
      10

    4. OldFella

    2. Using INDIRECT in the Formula That Defines a Graph's Data Range 10

      • OldFella
    3. Replies
      10
      Views
      7.7k
      10

    4. Carim

    2. how to change formula below to not average cells with 0?? 10

      • lize
      • lize
    3. Replies
      10
      Views
      1.2k
      10

    4. AliGW

    2. Trying to use data bar formatting 10

      • excelhatesme!
    3. Replies
      10
      Views
      2.3k
      10

    4. 63falcondude

    2. Find the row number of a value found in the second column of an array 10

      • spidykwya
    3. Replies
      10
      Views
      1.1k
      10

    4. Carim

    2. Gantt Chart - Data Bars not all correct color for each project 10

      • Webbers
    3. Replies
      10
      Views
      1.6k
      10

    4. Webbers

    2. Extract Substring from path 10

      • cutestuff
    3. Replies
      10
      Views
      1.6k
      10

    4. Carim

    2. LAZY TYPIST: use a column of predetermined items to fill a text box at need. 10

      • Blazingspleen
    3. Replies
      10
      Views
      1.4k
      10

    4. Logit

    2. double click macro for table 10

      • nitroxhaha
    3. Replies
      10
      Views
      6.3k
      10

    4. MandyRead

    2. Auto Add/Subtract 10

      • JJeffery99
    3. Replies
      10
      Views
      2.8k
      10

    4. yongle

    2. Copy entire row to another sheet if value matches 10

      • passer_by
    3. Replies
      10
      Views
      1.8k
      10

    4. royUK

Label

Display Options