Excel Formulas

Questions related specifically to the use of Excel formulas.

Mark All as Read

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

      • wittonline
    3. Replies
      1
      Views
      607
      1

    4. wittonline

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

      • wittonline
    3. Replies
      9
      Views
      1.4k
      9

    4. wittonline

    2. Stop Vlookup returning 0 2

      • Winwhite
    3. Replies
      2
      Views
      1.2k
      2

    4. Winwhite

    2. UDF in a Userform 3

      • wings
    3. Replies
      3
      Views
      343
      3

    4. royUK

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

      • WillAnt
    3. Replies
      1
      Views
      1.9k
      1

    4. royUK

    2. Last cell containing data in Dynamic Range 1

      • WillAnt
    3. Replies
      1
      Views
      592
      1

    4. royUK

    2. Integrate Formula into VLOOKUP 9

      • WillAnt
    3. Replies
      9
      Views
      1.1k
      9

    4. Carim

    2. Return Header Data for first consecutive cell 1

      • wildus
    3. Replies
      1
      Views
      244
      1

    4. Carim

    2. IFS function giving #NAME? error 1

      • wildeye
    3. Replies
      1
      Views
      1.1k
      1

    4. NBVC

    2. discount codes 1

      • whatisVBA
    3. Replies
      1
      Views
      900
      1

    4. Grimes0332

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

      • wes2706
    3. Replies
      1
      Views
      384
      1

    4. wittonline

    2. Conditional Formatting based on another cell having data 6

      • WendleB
    3. Replies
      6
      Views
      456
      6

    4. Carim

    2. Extract text string 5

      • Webbers
    3. Replies
      5
      Views
      827
      5

    4. KjBox

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

      • Webbers
    3. Replies
      3
      Views
      619
      3

    4. Carim

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

      • Webbers
    3. Replies
      10
      Views
      1.4k
      10

    4. Webbers

    2. Search Multiple Ranges for Keywords within Text Strings 4

      • Webbers
    3. Replies
      4
      Views
      586
      4

    4. Webbers

    2. If statement 10

      • waterscapes
    3. Replies
      10
      Views
      1k
      10

    4. Carim

    2. Calculate Holidays with Networkdays 1

      • Wasiq
    3. Replies
      1
      Views
      908
      1

    4. Ger Plante

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

      • Washerz
    3. Replies
      1
      Views
      3.5k
      1

    4. Carim

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

      • wangs930
    3. Replies
      7
      Views
      632
      7

    4. wangs930

Label

Display Options