Excel Formulas

Questions related specifically to the use of Excel formulas.

    1. Index Small function to skip blank rows 8

      • dloc_26
    2. Replies
      8
      Views
      4.8k
      8
    3. Roger1955

    1. IFERROR, ROUND and SUM together 2

      • DezB
      • DezB
    2. Replies
      2
      Views
      4.7k
      2
    3. DezB

    1. Converting Quarterly Data to Monthly Data 1

      • Rafaelbrians
    2. Replies
      1
      Views
      4.6k
      1
    3. Carim

    1. Find underline and bold text with cells. 14

      • cya
      • cya
    2. Replies
      14
      Views
      4.4k
      14
    3. Carim

    1. I want Vlookup to return Formula and take cell reference from Target sheet. 22

      • nilaymohit
    2. Replies
      22
      Views
      4.1k
      22
    3. MandyRead

    1. Convert pounds and ounces to decimal and other number questions 11

      • noyb1982
    2. Replies
      11
      Views
      4k
      11
    3. JonathanVH

    1. Find max value from vlookup against multiple sheets 12

      • CompleXcel
    2. Replies
      12
      Views
      4k
      12
    3. CompleXcel

    1. How to use indirect formula to show value AND formatting? 26

      • carissa
    2. Replies
      26
      Views
      3.9k
      26
    3. Carim

    1. Xlookup with duplicate values in return array 3

      • Aksaunder
    2. Replies
      3
      Views
      3.9k
      3
    3. Carim

    1. Excel formula to show text only IF another cell is greater than 0 5

      • Aikosassie2
    2. Replies
      5
      Views
      3.8k
      5
    3. Aikosassie2

    1. calculate the number of years and months as of today and round to the nearest year 2

      • milgrl3
    2. Replies
      2
      Views
      3.8k
      2
    3. AliGW

    1. Exact same formula different results. 28

      • her.rockstar
    2. Replies
      28
      Views
      3.7k
      28
    3. NBVC

    1. Indirect/substitute formula help 13

      • freddie0
    2. Replies
      13
      Views
      3.7k
      13
    3. GlennUK

    1. AverageIf #DIV/0! error 10

      • Murph0625
    2. Replies
      10
      Views
      3.5k
      10
    3. NBVC

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

      • B.W.B.
    2. Replies
      20
      Views
      3.5k
      20
    3. XOR LX

    1. Need help in COUNTIF formula 11

      • elsuji
    2. Replies
      11
      Views
      3.5k
      11
    3. royUK

    1. "tilde" in vlookup formula 13

      • Anri
      • Anri
    2. Replies
      13
      Views
      3.4k
      13
    3. Carim

    1. Generate cells with values from other cells 19

      • DataWarrior
    2. Replies
      19
      Views
      3.4k
      19
    3. DataWarrior

    1. concatenateif formula not working ? 5

      • jacjas
    2. Replies
      5
      Views
      3.3k
      5
    3. KjBox

    1. Match a value against a date and enter the matched value 41

      • khanaran
    2. Replies
      41
      Views
      3.3k
      41
    3. Carim

Label

Display Options