Excel Formulas

Questions related specifically to the use of Excel formulas.

    2. how to extract 10 digit mobile number within text or specialcharacter 4

      • PrasadK
    3. Replies
      4
      Views
      505
      4

    4. bosco_yip

    2. Count from Unique Criteria 6

      • Shawn Michaels
    3. Replies
      6
      Views
      463
      6

    4. Shawn Michaels

    2. Formula for: If a Cell contains text 3

      • JulianR
    3. Replies
      3
      Views
      318
      3

    4. royUK

    2. 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
    3. Replies
      6
      Views
      857
      6

    4. Ingo_Ingo

    2. SUMIFS with 2 values in Criteria 1 3

      • Raluca
    3. Replies
      3
      Views
      452
      3

    4. rory

    2. UDF in a Userform 3

      • wings
    3. Replies
      3
      Views
      304
      3

    4. royUK

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

      • tomchy
    3. Replies
      1
      Views
      344
      1

    4. rollis13

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

      • postingart003
    3. Replies
      0
      Views
      521

    2. 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
    3. Replies
      6
      Views
      664
      6

    4. dijoy

    2. Return Text Before Nth Instance of Particular Character 2

      • thenoodly1
    3. Replies
      2
      Views
      355
      2

    4. thenoodly1

    2. Transfer data from one sheet to another automatically 3

      • Santoshi Para
    3. Replies
      3
      Views
      374
      3

    4. royUK

    2. Find the smallest amount 5

      • Sir-Pops-A-Lot
    3. Replies
      5
      Views
      822
      5

    4. tr1face

    2. Returning Data if Two matches are made 1

      • chelly
    3. Replies
      1
      Views
      360
      1

    4. chelly

    2. Rank Issue using value from Pivot Table 1

      • Box Jockey
    3. Replies
      1
      Views
      224
      1

    4. royUK

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

      • cambos444
    3. Replies
      12
      Views
      818
      12

    4. alansidman

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

      • travellerva
    3. Replies
      3
      Views
      415
      3

    4. tr1face

    2. Form in Excel 1

      • Ankit4680
    3. Replies
      1
      Views
      275
      1

    4. royUK

    2. Sumif function not working.Returning zero 9

      • CapG
      • CapG
    3. Replies
      9
      Views
      835
      9

    4. Fluff13

    2. Count date occurrences in a comment cell 2

      • Raluca
    3. Replies
      2
      Views
      331
      2

    4. Raluca

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

      • cobber1418
    3. Replies
      5
      Views
      501
      5

    4. royUK

Label

Display Options