Excel Formulas

Questions related specifically to the use of Excel formulas.

    1. Sum Area Based on Compound Row and Column Criteria 13

      • DC Mega
    2. Replies
      13
      Views
      1.1k
      13
    3. Carim

    1. Conditional format formula 13

      • jl2509
    2. Replies
      13
      Views
      388
      13
    3. Carim

    1. Conditional Formatting: Trouble adding a col qualifier value into an existing formula 13

      • wittonline
    2. Replies
      13
      Views
      793
      13
    3. wittonline

    1. DIV/0 Error when dividing 0.00%'s 13

      • DezB
      • DezB
    2. Replies
      13
      Views
      763
      13
    3. Carim

    1. Sorting by phone #, phone # in different columns, phone # with extentions 13

      • FlailingEnginer
    2. Replies
      13
      Views
      1.1k
      13
    3. FlailingEnginer

    1. MODE MATCH Formula (for most common occurance) not considering entire range 13

      • wittonline
    2. Replies
      13
      Views
      1.1k
      13
    3. wittonline

    1. "tilde" in vlookup formula 13

      • Anri
      • Anri
    2. Replies
      13
      Views
      2k
      13
    3. Carim

    1. Subtracting time depending on text in a previous cell 13

      • CaulfieldS
    2. Replies
      13
      Views
      955
      13
    3. AliGW

    1. Display data from one tab as merged cells on another tab of workbook 12

      • ajrilo1
    2. Replies
      12
      Views
      409
      12
    3. ajrilo1

    1. Finding the Median for certain dates from a list of data 12

      • moyad612013
    2. Replies
      12
      Views
      1k
      12
    3. NBVC

    1. alert levels 12

      • zohar
    2. Replies
      12
      Views
      1.1k
      12
    3. zohar

    1. Vlookup or indexmatch or??? 12

      • ItsSugarBunny
    2. Replies
      12
      Views
      746
      12
    3. Carim

    1. Find max value from vlookup against multiple sheets 12

      • CompleXcel
    2. Replies
      12
      Views
      1.4k
      12
    3. CompleXcel

    1. How to use the =TODAY() for start up but freeze that date 12

      • shrnmabe
    2. Replies
      12
      Views
      558
      12
    3. zohar

    1. Vlookup value after comma+space & return each value seperated by comma+space 12

      • sandeepsandeep
    2. Replies
      12
      Views
      802
      12
    3. sandeepsandeep

    1. Single Search formula for two or more conditions? 12

      • B.W.B.
    2. Replies
      12
      Views
      646
      12
    3. AliGW

    1. Copy data from selected blocks of cells dependent of the month in a cell 12

      • DezB
    2. Replies
      12
      Views
      663
      12
    3. DezB

    1. Match relevant data again 12

      • bob22
    2. Replies
      12
      Views
      1k
      12
    3. bob22

    1. INDEX MATCH with multiple lookup_arrays/references 12

      • B.W.B.
    2. Replies
      12
      Views
      1.7k
      12
    3. B.W.B.

    1. Cell Value Fill Based on Color 11

      • dan_jordan84
    2. Replies
      11
      Views
      401
      11
    3. Carim

Display Options