Excel Formulas

Questions related specifically to the use of Excel formulas.

    2. Identify records based on multiple conditions & single occurance of value 8

      • ambquinn
    3. Replies
      8
      Views
      1.5k
      8

    4. Infomage

    2. SUMIF Totals based on multiple critertia 7

      • amanda0210
    3. Replies
      7
      Views
      1.2k
      7

    4. amanda0210

    2. using INDIRECT to set structured table reference in formula and return COUNTIF result based on another column value 2

      • alz1
      • alz1
    3. Replies
      2
      Views
      437
      2

    4. alz1

    2. VLookup to closed workbook 7

      • alring
    3. Replies
      7
      Views
      340
      7

    4. alring

    2. Formula to match multiple unique value's

      • Alphacino
      • Alphacino
    3. Replies
      0
      Views
      220

    2. Counting Baseball Series 9

      • Alix James
    3. Replies
      9
      Views
      618
      9

    4. AliGW

    2. Reverse Search 2

      • alibaba
    3. Replies
      2
      Views
      913
      2

    4. alibaba

    2. displaying values from a number of worksheets 2

      • alibaba
    3. Replies
      2
      Views
      794
      2

    4. alibaba

    2. Displaying value according to selected data 1

      • alibaba
    3. Replies
      1
      Views
      547
      1

    4. skywriter

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

      • alhagag
    3. Replies
      3
      Views
      654
      3

    4. dangelor

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

      • alfadaz
    3. Replies
      2
      Views
      325
      2

    4. alfadaz

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

      • alfadaz
    3. Replies
      3
      Views
      575
      3

    4. Fluff13

    2. Finding the earliest date/time when all tests parameters meet their respective targets (pass) 2

      • alex_a
    3. Replies
      2
      Views
      620
      2

    4. alex_a

    2. Need help with the lab test result cloese to 24 hours

      • alex_a
    3. Replies
      0
      Views
      219

    2. Split data from date range to Financial year buckets

      • Aleem
    3. Replies
      0
      Views
      422

    2. SUMPRODUCT over dynamic range - No VBA 1

      • al4xms
    3. Replies
      1
      Views
      865
      1

    4. AliGW

    2. Xlookup with duplicate values in return array 3

      • Aksaunder
    3. Replies
      3
      Views
      4k
      3

    4. Carim

    2. Mapping in Excel 2

      • akovachki
    3. Replies
      2
      Views
      484
      2

    4. akovachki

    2. sum(sumifs... 2

      • akbarnikain
    3. Replies
      2
      Views
      393
      2

    4. akbarnikain

    2. Application.WorksheetFuntion.SumIfs 1

      • akbarnikain
    3. Replies
      1
      Views
      311
      1

    4. Carim

Label

Display Options