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. Flag if data is in top 80% of range 8

      • goin4boge
    3. Replies
      8
      Views
      6.4k
      8

    4. S O

    2. Index / Match + Sort / Filter Issue 9

      • swillisam
    3. Replies
      9
      Views
      7.1k
      9

    4. swillisam

    2. Find and print specific amount of characters after some symbols 1

      • BartesGaming
    3. Replies
      1
      Views
      635
      1

    4. NBVC

    2. Help with shifting table columns 1

      • flashkid10
    3. Replies
      1
      Views
      619
      1

    4. Luke M

    2. Calculate days between 2 dates 3

      • angelic1
    3. Replies
      3
      Views
      2.9k
      3

    4. S O

    2. Quartile formula error 3

      • aalexander
    3. Replies
      3
      Views
      1k
      3

    4. joeu2004

    2. Looking Up Closest Match Between Two Columns and Within That Row 1

      • abba92
    3. Replies
      1
      Views
      665
      1

    4. Luke M

    2. Only if a time is larger than a different time so how larger it is. 1

      • meggiej
    3. Replies
      1
      Views
      586
      1

    4. alansidman

    2. Lookup Multiple Criteria in a Table and Return Header 1

      • abba92
    3. Replies
      1
      Views
      839
      1

    4. abba92

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

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

    4. B.W.B.

    2. IF forumla to check if a value falls between two numbers 1

      • GG88
    3. Replies
      1
      Views
      1.7k
      1

    4. NBVC

    2. displaying values from a number of worksheets 2

      • alibaba
    3. Replies
      2
      Views
      915
      2

    4. alibaba

    2. Displaying value according to selected data 1

      • alibaba
    3. Replies
      1
      Views
      626
      1

    4. skywriter

    2. Return the last number in a range that is not in a coloured cell 3

      • vanhunk
    3. Replies
      3
      Views
      966
      3

    4. vanhunk

    2. Find Max number value from text-number cell? 20

      • B.W.B.
    3. Replies
      20
      Views
      4.4k
      20

    4. XOR LX

    2. Date string conversion 6

      • waldis
    3. Replies
      6
      Views
      1.2k
      6

    4. skywriter

    2. Help Needed with If Statement, 5

      • Frederus
    3. Replies
      5
      Views
      1.2k
      5

    4. Infomage

    2. pick items from a list and total them 2

      • rnomis
    3. Replies
      2
      Views
      735
      2

    4. rnomis

    2. Nested array formula for a SUMPRODUCT operation 3

      • Zapillo
    3. Replies
      3
      Views
      1k
      3

    4. NBVC

    2. Position code to be extract based on multiple criteria 3

      • ajaypal.sp
    3. Replies
      3
      Views
      1.1k
      3

    4. cytop

Label

Display Options