Excel Formulas

Questions related specifically to the use of Excel formulas.

    1. Unable to perform the index and multiple match array function 4

      • Srisreshtan
    2. Replies
      4
      Views
      288
      4
    3. Fluff13

    1. Unable to perform picture lookup in excel 4

      • Srisreshtan
    2. Replies
      4
      Views
      412
      4
    3. Srisreshtan

    1. Turn Surname and Firstname around 5

      • DezB
      • DezB
    2. Replies
      5
      Views
      147
      5
    3. DezB

    1. Turn SUMIFS negative value into 0 (ZERO) 6

      • jentry.highland
    2. Replies
      6
      Views
      191
      6
    3. Carim

    1. Trying to use data bar formatting 10

      • excelhatesme!
    2. Replies
      10
      Views
      588
      10
    3. 63falcondude

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

      • wittonline
    2. Replies
      9
      Views
      567
      9
    3. wittonline

    1. Trying to retrieve Data over multiple Rows and Columns 3

      • Trompie2017
    2. Replies
      3
      Views
      418
      3
    3. CaulfieldS

    1. Trying to pull specific data from sheet1 to other sheets if it meets criteria 10

      • blade671
    2. Replies
      10
      Views
      1.2k
      10
    3. blade671

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

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

    1. Trying to generate actual selling day of current month and current year 6

      • dvswindler
    2. Replies
      6
      Views
      1.6k
      6
    3. FDibbins

    1. Trying to extract data meeting 3 conditions 8

      • Amitouj
    2. Replies
      8
      Views
      537
      8
    3. AlanSidman

    1. Trying to create formula to exclude any cells that contain the word "D/C" 7

      • Anmari
    2. Replies
      7
      Views
      873
      7
    3. Anmari

    1. True / False statement if times are within x minutes of each other 3

      • Shezmo1
    2. Replies
      3
      Views
      141
      3
    3. Infomage

    1. Trouble with Dynamic Ranges and Dynamic Charts 1

      • hmsiegel
    2. Replies
      1
      Views
      88
      1
    3. hmsiegel

    1. Trouble with a SumIfs Forumula in a Daily Budget 4

      • JC1938
    2. Replies
      4
      Views
      83
      4
    3. Carim

    1. Trouble w VLOOKUP (later in formula) displaying "0"s or #VALUE! 11

      • wittonline
    2. Replies
      11
      Views
      356
      11
    3. wittonline

    1. TREND Function to Ignore Zeros 7

      • msquared99
    2. Replies
      7
      Views
      414
      7
    3. Carim

    1. Transfering data 3

      • kennethbrandon
    2. Replies
      3
      Views
      369
      3
    3. AlanSidman

    1. Transfer or move formula 1

      • JSQUIRES
    2. Replies
      1
      Views
      61
      1
    3. AlanSidman

    1. Tracking hours and pay outstanding in spreadsheet 1

      • daamyour
    2. Replies
      1
      Views
      392
      1
    3. richadj4

Display Options