Excel Formulas

Questions related specifically to the use of Excel formulas.

    1. Excel formula to show text only IF another cell is greater than 0 5

      • Aikosassie2
    2. Replies
      5
      Views
      2k
      5
    3. Aikosassie2

    1. Ranking formula 9

      • airbisglenn
    2. Replies
      9
      Views
      519
      9
    3. rory

    1. Position code to be extract based on multiple criteria 3

      • ajaypal.sp
    2. Replies
      3
      Views
      690
      3
    3. cytop

    1. Rank Occurrences of text with If condition 7

      • ajhavery
    2. Replies
      7
      Views
      530
      7
    3. Carim

    1. Modifying a formula 2

      • ajrilo1
    2. Replies
      2
      Views
      182
      2
    3. ajrilo1

    1. Multiple sets of data in single cell 5

      • ajrilo1
    2. Replies
      5
      Views
      233
      5
    3. royUK

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

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

    1. Dynamic defined name for worksheet columns

      • akbarnikain
    2. Replies
      0
      Views
      132
    1. Application.WorksheetFuntion.SumIfs 1

      • akbarnikain
    2. Replies
      1
      Views
      186
      1
    3. Carim

    1. sum(sumifs... 2

      • akbarnikain
    2. Replies
      2
      Views
      231
      2
    3. akbarnikain

    1. Mapping in Excel 2

      • akovachki
    2. Replies
      2
      Views
      249
      2
    3. akovachki

    1. Xlookup with duplicate values in return array 3

      • Aksaunder
    2. Replies
      3
      Views
      218
      3
    3. Carim

    1. SUMPRODUCT over dynamic range - No VBA 1

      • al4xms
    2. Replies
      1
      Views
      651
      1
    3. AliGW

    1. Split data from date range to Financial year buckets

      • Aleem
    2. Replies
      0
      Views
      197
    1. Need help with the lab test result cloese to 24 hours

      • alex_a
    2. Replies
      0
      Views
      149
    1. Finding the earliest date/time when all tests parameters meet their respective targets (pass) 2

      • alex_a
    2. Replies
      2
      Views
      386
      2
    3. alex_a

    1. Sum of a column and column total showing different results 3

      • alfadaz
    2. Replies
      3
      Views
      329
      3
    3. Fluff13

    1. get data contains big and small letter and number 3

      • alhagag
    2. Replies
      3
      Views
      473
      3
    3. dangelor

    1. Displaying value according to selected data 1

      • alibaba
    2. Replies
      1
      Views
      409
      1
    3. skywriter

    1. displaying values from a number of worksheets 2

      • alibaba
    2. Replies
      2
      Views
      582
      2
    3. alibaba

Display Options