Excel Formulas

Questions related specifically to the use of Excel formulas.

    1. Increment Alphanumeric cell values based on a range of alphanumeric cell values 3

      • aijazamg
    2. Replies
      3
      Views
      1.1k
      3
    3. AliGW

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

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

    1. Ranking formula 9

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

    1. Conditional rearrangement of data 6

      • AivarsR
    2. Replies
      6
      Views
      361
      6
    3. bosco_yip

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

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

    1. Rank Occurrences of text with If condition 7

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

    1. Modifying a formula 2

      • ajrilo1
    2. Replies
      2
      Views
      319
      2
    3. ajrilo1

    1. Multiple sets of data in single cell 5

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

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

      • ajrilo1
    2. Replies
      12
      Views
      1k
      12
    3. ajrilo1

    1. Dynamic defined name for worksheet columns

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

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

    1. sum(sumifs... 2

      • akbarnikain
    2. Replies
      2
      Views
      311
      2
    3. akbarnikain

    1. Mapping in Excel 2

      • akovachki
    2. Replies
      2
      Views
      380
      2
    3. akovachki

    1. Xlookup with duplicate values in return array 3

      • Aksaunder
    2. Replies
      3
      Views
      1.7k
      3
    3. Carim

    1. SUMPRODUCT over dynamic range - No VBA 1

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

    1. Split data from date range to Financial year buckets

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

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

      • alex_a
    2. Replies
      2
      Views
      497
      2
    3. alex_a

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

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

    1. COUNTIF - First char is S, Second can be any number, but not a letter 2

      • alfadaz
    2. Replies
      2
      Views
      159
      2
    3. alfadaz

Display Options