Excel Formulas

Questions related specifically to the use of Excel formulas.

    1. Index Match over multiple fields 1

      • nl05369
    2. Replies
      1
      Views
      251
      1
    3. nl05369

    1. Pivot - Adding Column for % Percentage 1

      • nitesh_greatie
    2. Replies
      1
      Views
      436
      1
    3. Carim

    1. Reverse Lookup Function 1

      • Chetu1980
    2. Replies
      1
      Views
      291
      1
    3. AliGW

    1. One loan payment ends...another begins! 1

      • Leaf2018
    2. Replies
      1
      Views
      193
      1
    3. Carim

    1. Diminishing Returns/Optimal Spend 1

      • MysticGenius
    2. Replies
      1
      Views
      850
      1
    3. AliGW

    1. How to fill missing enteries in column A, and add respective corresponding entries 1

      • JYousuf
    2. Replies
      1
      Views
      243
      1
    3. alansidman

    1. IFNA and IFError in 2003 1

      • Rededdie
    2. Replies
      1
      Views
      1k
      1
    3. Rededdie

    1. Is time within a given range? 1

      • Sicarii
    2. Replies
      1
      Views
      444
      1
    3. Carim

    1. Converting Quarterly Data to Monthly Data 1

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

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

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

    1. Perform a calculation based on criteria found using Index Match 1

      • manster_mg
    2. Replies
      1
      Views
      309
      1
    3. manster_mg

    1. How to make a report number with spaces ascend in proper order 1

      • Dag3832
    2. Replies
      1
      Views
      210
      1
    3. Carim

    1. lookup using last 3 numbers 1

      • jl2509
    2. Replies
      1
      Views
      236
      1
    3. jl2509

    1. Multiple Sheets Emp work map to Single Sheet Summary 1

      • n3_1358
    2. Replies
      1
      Views
      232
      1
    3. Carim

    1. Return Header Data for first consecutive cell 1

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

    1. getting data from Reference Sheet 1

      • Kiwi den
    2. Replies
      1
      Views
      229
      1
    3. JonathanVH

    1. Avoid Summing Duplicate Numbers 1

      • Screminflea
    2. Replies
      1
      Views
      192
      1
    3. Carim

    1. How to remove unwanted test from string ? 1

      • Xani
      • Xani
    2. Replies
      1
      Views
      349
      1
    3. XenoCode

    1. Associate values of columns 1

      • saraa11
    2. Replies
      1
      Views
      205
      1
    3. Carim

    1. PROMPTLY. help repair a corrupted Excel file (2003 release version) 1

      • brioche
    2. Replies
      1
      Views
      248
      1
    3. AliGW

Label

Display Options