Excel Formulas

Questions related specifically to the use of Excel formulas.

Mark All as Read

    2. Index Small function to skip blank rows 8

      • dloc_26
    3. Replies
      8
      Views
      5k
      8

    4. Roger1955

    2. Format Cell Color if Adjacent cell is blank 4

      • scubastu01
    3. Replies
      4
      Views
      5k
      4

    4. scubastu01

    2. Find underline and bold text with cells. 14

      • cya
      • cya
    3. Replies
      14
      Views
      5k
      14

    4. Carim

    2. Converting Quarterly Data to Monthly Data 1

      • Rafaelbrians
    3. Replies
      1
      Views
      4.9k
      1

    4. Carim

    2. Find max value from vlookup against multiple sheets 12

      • CompleXcel
    3. Replies
      12
      Views
      4.6k
      12

    4. CompleXcel

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

      • noyb1982
    3. Replies
      11
      Views
      4.6k
      11

    4. JonathanVH

    2. Xlookup with duplicate values in return array 3

      • Aksaunder
    3. Replies
      3
      Views
      4.5k
      3

    4. Carim

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

      • carissa
    3. Replies
      26
      Views
      4.4k
      26

    4. Carim

    2. Indirect/substitute formula help 13

      • freddie0
    3. Replies
      13
      Views
      4.3k
      13

    4. GlennUK

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

      • nilaymohit
    3. Replies
      22
      Views
      4.2k
      22

    4. MandyRead

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

      • Aikosassie2
    3. Replies
      5
      Views
      4.2k
      5

    4. Aikosassie2

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

      • milgrl3
    3. Replies
      2
      Views
      4.1k
      2

    4. AliGW

    2. Exact same formula different results. 28

      • her.rockstar
    3. Replies
      28
      Views
      3.9k
      28

    4. NBVC

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

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

    4. XOR LX

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

      • khanaran
    3. Replies
      41
      Views
      3.7k
      41

    4. Carim

    2. AverageIf #DIV/0! error 10

      • Murph0625
    3. Replies
      10
      Views
      3.7k
      10

    4. NBVC

    2. If cell is not empty, copy row... 9

      • micvoo
    3. Replies
      9
      Views
      3.6k
      9

    4. micvoo

    2. Need help in COUNTIF formula 11

      • elsuji
    3. Replies
      11
      Views
      3.6k
      11

    4. royUK

    2. "tilde" in vlookup formula 13

      • Anri
      • Anri
    3. Replies
      13
      Views
      3.6k
      13

    4. Carim

    2. concatenateif formula not working ? 5

      • jacjas
    3. Replies
      5
      Views
      3.5k
      5

    4. KjBox

Label

Display Options