Excel Formulas

Questions related specifically to the use of Excel formulas.

    1. Trying to get AVE &SUM, considering code in the calcs; not dependent on specific cols 1

      • wittonline
    2. Replies
      1
      Views
      584
      1
    3. wittonline

    1. Trying to understand cell formulas when extra characters used, learn to SUM and AVE 9

      • wittonline
    2. Replies
      9
      Views
      1.3k
      9
    3. wittonline

    1. Stop Vlookup returning 0 2

      • Winwhite
    2. Replies
      2
      Views
      1.1k
      2
    3. Winwhite

    1. UDF in a Userform 3

      • wings
    2. Replies
      3
      Views
      306
      3
    3. royUK

    1. Retrieve data from last row / cell in Dynamic Range 1

      • WillAnt
    2. Replies
      1
      Views
      1.7k
      1
    3. royUK

    1. Last cell containing data in Dynamic Range 1

      • WillAnt
    2. Replies
      1
      Views
      531
      1
    3. royUK

    1. Integrate Formula into VLOOKUP 9

      • WillAnt
    2. Replies
      9
      Views
      1k
      9
    3. Carim

    1. Return Header Data for first consecutive cell 1

      • wildus
    2. Replies
      1
      Views
      227
      1
    3. Carim

    1. IFS function giving #NAME? error 1

      • wildeye
    2. Replies
      1
      Views
      997
      1
    3. NBVC

    1. discount codes 1

      • whatisVBA
    2. Replies
      1
      Views
      853
      1
    3. Grimes0332

    1. Use a cell as reference to sheet to look in 1

      • wes2706
    2. Replies
      1
      Views
      345
      1
    3. wittonline

    1. Conditional Formatting based on another cell having data 6

      • WendleB
    2. Replies
      6
      Views
      409
      6
    3. Carim

    1. Extract text string 5

      • Webbers
    2. Replies
      5
      Views
      791
      5
    3. KjBox

    1. Count with multiple criteria including a date plus an "or" variable 3

      • Webbers
    2. Replies
      3
      Views
      564
      3
    3. Carim

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

      • Webbers
    2. Replies
      10
      Views
      1.3k
      10
    3. Webbers

    1. Search Multiple Ranges for Keywords within Text Strings 4

      • Webbers
    2. Replies
      4
      Views
      539
      4
    3. Webbers

    1. If statement 10

      • waterscapes
    2. Replies
      10
      Views
      990
      10
    3. Carim

    1. Calculate Holidays with Networkdays 1

      • Wasiq
    2. Replies
      1
      Views
      883
      1
    3. Ger Plante

    1. VLookup Formula that can change Negative number to Positive and leave Positive 1

      • Washerz
    2. Replies
      1
      Views
      2.9k
      1
    3. Carim

    1. Need help creating a formula that automatically reallocates unspent funds 7

      • wangs930
    2. Replies
      7
      Views
      581
      7
    3. wangs930

Label

Display Options