Excel Formulas

Questions related specifically to the use of Excel formulas.

    1. Formula for: If a Cell contains text 3

      • JulianR
    2. Replies
      3
      Views
      136
      3
    3. royUK

    1. SUMIFS with 2 values in Criteria 1 3

      • Raluca
    2. Replies
      3
      Views
      271
      3
    3. rory

    1. UDF in a Userform 3

      • wings
    2. Replies
      3
      Views
      137
      3
    3. royUK

    1. Matching a name across 2 sheets and then pulling a value from sheet2 and marking sheet1 with a yes based on partial text 6

      • PLucas1
    2. Replies
      6
      Views
      607
      6
    3. Ingo_Ingo

    1. Extract Year part from Date and convert to text 1

      • tomchy
    2. Replies
      1
      Views
      195
      1
    3. rollis13

    1. Please help to make organized data after selection of drop drop box

      • postingart003
    2. Replies
      0
      Views
      397
    1. Extract numbers after specific text in a text string with bracket for negative values and divide the number by 100 if letter 'c' associated with number 6

      • dijoy
    2. Replies
      6
      Views
      425
      6
    3. dijoy

    1. Return Text Before Nth Instance of Particular Character 2

      • thenoodly1
    2. Replies
      2
      Views
      212
      2
    3. thenoodly1

    1. Transfer data from one sheet to another automatically 3

      • Santoshi Para
    2. Replies
      3
      Views
      198
      3
    3. royUK

    1. Find the smallest amount 5

      • Sir-Pops-A-Lot
    2. Replies
      5
      Views
      606
      5
    3. tr1face

    1. Rank Issue using value from Pivot Table 1

      • Box Jockey
    2. Replies
      1
      Views
      115
      1
    3. royUK

    1. Returning 10 largest values when looking up in a list! 12

      • cambos444
    2. Replies
      12
      Views
      388
      12
    3. alansidman

    1. Form in Excel 1

      • Ankit4680
    2. Replies
      1
      Views
      171
      1
    3. royUK

    1. I need to reference cells in a row on one sheet as a column in another 3

      • travellerva
    2. Replies
      3
      Views
      253
      3
    3. tr1face

    1. Count date occurrences in a comment cell 2

      • Raluca
    2. Replies
      2
      Views
      194
      2
    3. Raluca

    1. Sumif function not working.Returning zero 9

      • CapG
      • CapG
    2. Replies
      9
      Views
      420
      9
    3. Fluff13

    1. Countifs formula to only count 'Last month' 5

      • cobber1418
    2. Replies
      5
      Views
      286
      5
    3. royUK

    1. Countifs formula using A:A or A2:A1000 4

      • cobber1418
    2. Replies
      4
      Views
      719
      4
    3. cobber1418

    1. growing range 7

      • Eusebious
    2. Replies
      7
      Views
      2.2k
      7
    3. Eusebious

    1. Countifs date formula 14

      • cobber1418
    2. Replies
      14
      Views
      1.4k
      14
    3. royUK

Display Options