Excel Formulas

Questions related specifically to the use of Excel formulas.

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

      • mljohn
    3. Replies
      3
      Views
      193
      3

    4. mljohn

    2. ​Calculate Duration between two dates 2

      • Xani
    3. Replies
      2
      Views
      224
      2

    4. Xani

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

      • pulsenation
    3. Replies
      6
      Views
      212
      6

    4. royUK

    2. Average Data Between Certain Months 11

      • palchy
    3. Replies
      11
      Views
      565
      11

    4. palchy

    2. Every nth cell into multiple cells 1

      • FINgers
    3. Replies
      1
      Views
      159
      1

    4. FINgers

    2. Get companies with specific earning announcement dates via Bloomberg

      • Evil Devil
    3. Replies
      0
      Views
      173

    2. Formulas are not updating as I change data 3

      • dejayajay
    3. Replies
      3
      Views
      213
      3

    4. royUK

    2. Sumifs with true/false 7

      • Natit1
    3. Replies
      7
      Views
      356
      7

    4. Natit1

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

      • Faygin
    3. Replies
      4
      Views
      262
      4

    4. Pecoflyer

    2. allocate a value that reads from the cell 4

      • khanaran
    3. Replies
      4
      Views
      327
      4

    4. khanaran

    2. Pop up chart 5

      • DezB
      • DezB
    3. Replies
      5
      Views
      649
      5

    4. royUK

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

      • emthaolinh
    3. Replies
      1
      Views
      344
      1

    4. royUK

    2. Calculating a numeric score from a qualitative score 1

      • la_coyote
    3. Replies
      1
      Views
      257
      1

    4. bosco_yip

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

      • UpToSpeed
    3. Replies
      6
      Views
      375
      6

    4. alansidman

    2. Calculate Duration in Hours from Date 5

      • KayPee22
    3. Replies
      5
      Views
      364
      5

    4. royUK

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

      • khanaran
    3. Replies
      21
      Views
      1.9k
      21

    4. bosco_yip

    2. sum total invoice value on list line 3

      • sathishmadhav1
    3. Replies
      3
      Views
      275
      3

    4. Fluff13

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

      • slaphead007
    3. Replies
      3
      Views
      287
      3

    4. royUK

    2. Formula for picking every other cell? 5

      • PuntingJawa
    3. Replies
      5
      Views
      392
      5

    4. PuntingJawa

    2. countif confusion 2

      • Boxxcar
    3. Replies
      2
      Views
      206
      2

    4. rory

Display Options