Excel Formulas

Questions related specifically to the use of Excel formulas.

    1. Remove non-numeric characters before first numeric character 3

      • mljohn
    2. Replies
      3
      Views
      193
      3
    3. mljohn

    1. ​Calculate Duration between two dates 2

      • Xani
    2. Replies
      2
      Views
      224
      2
    3. Xani

    1. Looking to return a text value in a single cell if a specific letter is identified in a range 6

      • pulsenation
    2. Replies
      6
      Views
      212
      6
    3. royUK

    1. Average Data Between Certain Months 11

      • palchy
    2. Replies
      11
      Views
      565
      11
    3. palchy

    1. Every nth cell into multiple cells 1

      • FINgers
    2. Replies
      1
      Views
      159
      1
    3. FINgers

    1. Get companies with specific earning announcement dates via Bloomberg

      • Evil Devil
    2. Replies
      0
      Views
      173
    1. Formulas are not updating as I change data 3

      • dejayajay
    2. Replies
      3
      Views
      213
      3
    3. royUK

    1. Sumifs with true/false 7

      • Natit1
    2. Replies
      7
      Views
      356
      7
    3. Natit1

    1. NumberFormat = "[h]:mm" 4

      • Faygin
    2. Replies
      4
      Views
      262
      4
    3. Pecoflyer

    1. allocate a value that reads from the cell 4

      • khanaran
    2. Replies
      4
      Views
      327
      4
    3. khanaran

    1. Pop up chart 5

      • DezB
      • DezB
    2. Replies
      5
      Views
      649
      5
    3. royUK

    1. index match using multiple spreadsheets return text YES OR NO 1

      • emthaolinh
    2. Replies
      1
      Views
      344
      1
    3. royUK

    1. Calculating a numeric score from a qualitative score 1

      • la_coyote
    2. Replies
      1
      Views
      257
      1
    3. bosco_yip

    1. Help Inverting a table - list of requirements with associated tests to become a list of tests with associated requirements 6

      • UpToSpeed
    2. Replies
      6
      Views
      375
      6
    3. alansidman

    1. Calculate Duration in Hours from Date 5

      • KayPee22
    2. Replies
      5
      Views
      364
      5
    3. royUK

    1. Formula to convert a gregorian date to a chinese date 21

      • khanaran
    2. Replies
      21
      Views
      1.9k
      21
    3. bosco_yip

    1. sum total invoice value on list line 3

      • sathishmadhav1
    2. Replies
      3
      Views
      275
      3
    3. Fluff13

    1. How to calculate totals on 1st of each month 3

      • slaphead007
    2. Replies
      3
      Views
      287
      3
    3. royUK

    1. Formula for picking every other cell? 5

      • PuntingJawa
    2. Replies
      5
      Views
      392
      5
    3. PuntingJawa

    1. countif confusion 2

      • Boxxcar
    2. Replies
      2
      Views
      206
      2
    3. rory

Display Options