Search:

Tag: aggregate

Page 1 of 3 1 2 3

Search: Replies Views Search took 0.00 seconds.

  1. Getting 0 from Aggregate function while result shown in formula pop-up is positive

    Started by ViniciusLima‎, 06-16-2025 10:17 AM
    aggregate, excel, formula 4 Attachment(s)
    • 302
    Last Post: 07-02-2025 12:48 PM
    by JeteMc  Go to last post

    Forum:
    Excel Formulas & Functions

  2. [SOLVED] Small with multiple criteria across rows and columns

    Started by 77highland‎, 04-29-2025 09:29 AM
    aggregate, filter, small 6 Attachment(s)
    • 432
    Last Post: 05-01-2025 11:05 AM
    by CheeseSandwich  Go to last post

    Forum:
    Excel Formulas & Functions

  3. [SOLVED] List dates if asset number is different and plot tasks

    Started by 77highland‎, 03-26-2025 01:04 PM
    aggregate, index, match, xlookup 7 Attachment(s)
    • 425
    Last Post: 03-28-2025 08:36 AM
    by JeteMc  Go to last post

    Forum:
    Excel Formulas & Functions

  4. [SOLVED] Count with criteria in different ranges

    Started by 77highland‎, 03-25-2025 08:34 AM
    aggregate, count, sumproduct 4 Attachment(s)
    • 248
    Last Post: 03-25-2025 10:54 AM
    by windknife  Go to last post

    Forum:
    Excel Formulas & Functions

  5. Create Formula to show for filtered tick boxes

    Started by CluelessCounter‎, 03-03-2025 07:01 AM
    aggregate, countif, filter
    • 239
    Last Post: 03-03-2025 09:51 AM
    by TMS  Go to last post

    Forum:
    Excel Formulas & Functions

  6. Transform donation list into single rows per donor eg. Donor, Date1, Amt1, Date2, Amt2 etc

    Started by Chicara‎, 01-16-2025 01:06 PM
    aggregate, power query, transform table, unpivot data 2 Attachment(s)
    • 432
    Last Post: 01-17-2025 10:20 PM
    by protonLeah  Go to last post

    Forum:
    Excel Charting & Pivots

  7. [SOLVED] MINIFS and hidden data

    Started by cliffoxie‎, 12-12-2024 11:03 PM
    aggregate, minifs 3 Attachment(s)
    • 631
    Last Post: 12-13-2024 06:29 PM
    by cliffoxie  Go to last post

    Forum:
    Excel Formulas & Functions

  8. [SOLVED] INDIRECT ADDRESS #REF error

    Started by Stuepef‎, 09-09-2024 10:08 AM
    aggregate, indirect, indirect address, rows 1 Attachment(s)
    • 382
    Last Post: 09-12-2024 11:04 AM
    by Stuepef  Go to last post

    Forum:
    Excel Formulas & Functions

  9. [SOLVED] Sort w/o helper column?

    Started by B.W.B.‎, 08-26-2024 04:00 AM
    aggregate, helper column, index, small, sort 2 Attachment(s)
    • 489
    Last Post: 08-26-2024 07:37 AM
    by B.W.B.  Go to last post

    Forum:
    Excel Formulas & Functions

  10. [SOLVED] I'm always missing that one result?

    Started by B.W.B.‎, 08-16-2024 11:04 AM
    aggregate, match. index, small 3 Attachment(s)
    • 597
    Last Post: 08-22-2024 10:00 AM
    by romperstomper  Go to last post

    Forum:
    Excel Formulas & Functions

  11. [SOLVED] Need second smallest/largest.

    Started by B.W.B.‎, 02-07-2024 02:57 PM
    aggregate, array, large, small 2 Attachment(s)
    • 298
    Last Post: 02-07-2024 04:05 PM
    by DJunqueira  Go to last post

    Forum:
    Excel Formulas & Functions

  12. INDEX MATCH with multiple columns

    Started by Stuepef‎, 10-02-2023 01:08 PM
    aggregate, columns, columns as row, index & match, rows 5 Attachment(s)
    • 638
    Last Post: 10-03-2023 06:52 AM
    by Czeslaw  Go to last post

    Forum:
    Excel Formulas & Functions

  13. Aggregate of Multiple columns IF a condition is met

    Started by Larry1957‎, 09-16-2023 09:29 PM
    aggregate 2 Attachment(s)
    • 837
    Last Post: 09-17-2023 06:56 AM
    by Larry1957  Go to last post

    Forum:
    Excel Formulas & Functions

  14. Formula Issue - Retreiving Data from one sheet to the other with same identifiers

    Started by Guitarist‎, 06-05-2023 11:55 AM
    aggregate, formula, iferror 2 Attachment(s)
    • 372
    Last Post: 06-05-2023 12:28 PM
    by AliGW  Go to last post

    Forum:
    Excel Formulas & Functions

  15. Power Query Multiplying Aggregated field

    Started by Dicken‎, 04-14-2023 12:03 PM
    aggregate, merge, power queyr 1 Attachment(s)
    • 802
    Last Post: 04-14-2023 12:03 PM
    by Dicken  Go to last post

    Forum:
    Office 365

  16. [SOLVED] Search a text for a array of values

    Started by amith4455‎, 04-03-2023 11:04 AM
    aggregate, array, index, search 2 Attachment(s)
    • 596
    Last Post: 04-03-2023 12:21 PM
    by windknife  Go to last post

    Forum:
    Excel Formulas & Functions

  17. [SOLVED] Subtotal/Aggregate Not Working Help

    Started by oliveloaf‎, 01-09-2023 06:37 PM
    aggregate, subtotal function 1 Attachment(s)
    • 816
    Last Post: 01-10-2023 05:19 PM
    by Croweater  Go to last post

    Forum:
    Excel Formulas & Functions

  18. match partial or complete text and match in another column to extract index value

    Started by tabkaz‎, 11-25-2022 12:14 AM
    aggregate, find, index & match, search & extract 4 Attachment(s)
    • 822
    Last Post: 11-26-2022 04:58 PM
    by MarvinP  Go to last post

    Forum:
    Excel Formulas & Functions

  19. Prevent certain input from appearing in a range

    Started by Jude_Long‎, 09-26-2022 06:44 AM
    aggregate, countif, iferror 1 Attachment(s)
    • 479
    Last Post: 09-27-2022 02:28 AM
    by Jude_Long  Go to last post

    Forum:
    Excel General

  20. Optimizing the Formula to run faster Finding the latest record

    Started by zaveed‎, 04-19-2022 04:19 AM
    aggregate, optimize, slow calculations 4 Attachment(s)
    • 748
    Last Post: 04-19-2022 07:35 AM
    by zaveed  Go to last post

    Forum:
    Excel Formulas & Functions

  21. Aggregate statistics across multiple sheets if multiple critereon met

    Started by newandnotverygood‎, 03-09-2022 11:36 AM
    aggregate, complex, data 1 Attachment(s)
    • 506
    Last Post: 03-09-2022 12:40 PM
    by Richard Buttrey  Go to last post

    Forum:
    Excel Formulas & Functions

  22. 1 value and return multiple results

    Started by ToonV1‎, 02-11-2022 07:21 AM
    aggregate, excel, match & index 3 Attachment(s)
    • 543
    Last Post: 02-11-2022 08:58 AM
    by AliGW  Go to last post

    Forum:
    Excel Formulas & Functions

  23. Match index formula not working

    Started by dagame98‎, 07-29-2021 05:33 PM
    aggregate, match & index
    • 591
    Last Post: 07-29-2021 10:40 PM
    by josephteh  Go to last post

    Forum:
    Excel General

  24. A changing frequency table

    Started by CPILon‎, 06-09-2021 10:28 AM
    aggregate, dynamic, frequency
    • 600
    Last Post: 06-09-2021 10:28 AM
    by CPILon  Go to last post

    Forum:
    Excel Formulas & Functions

  25. Displaying data from multiple sheets with multiple criteria

    Started by afreed33‎, 05-03-2021 07:31 PM
    aggregate, criteria as text, function 1 Attachment(s)
    • 547
    Last Post: 05-03-2021 08:23 PM
    by thenewkidd  Go to last post

    Forum:
    Excel Formulas & Functions

  26. How to convert excel aggregation/consolidation to google sheets

    Started by ISH1959‎, 02-18-2021 08:36 AM
    aggregate, conolidate, sheetrange
    • 789
    Last Post: 02-18-2021 08:40 AM
    by Glenn Kennedy  Go to last post

    Forum:
    For Other Platforms(Mac, Google Docs, Mobile OS etc)

  27. [SOLVED] Create an advanced report to show average price per brand (sorted by country+ cat of item)

    Started by Luu4466‎, 12-11-2020 03:41 AM
    aggregate, average, index, sort 3 Attachment(s)
    • 763
    Last Post: 12-14-2020 05:52 AM
    by Keebellah  Go to last post

    Forum:
    Excel Formulas & Functions

  28. Aggregate PIVOT TABLE with custom Cumulative Product formula

    Started by do34‎, 11-23-2020 11:21 PM
    aggregate, cumulative, pivot, pivot-table, product 4 Attachment(s)
    • 904
    Last Post: 11-24-2020 12:55 AM
    by bebo021999  Go to last post

    Forum:
    Excel Charting & Pivots

  29. [SOLVED] Creating an Array formula which calculates depending on what is filtered

    Started by Dandruce‎, 11-12-2020 05:37 AM
    aggregate, array, match and add, sum
    • 833
    Last Post: 11-16-2020 10:18 AM
    by JeteMc  Go to last post

    Forum:
    Excel General

  30. [SOLVED] Calculate cumulative sums and obtain highest value based on it

    Started by Rehman5000‎, 11-07-2020 01:40 AM
    aggregate, cumulative sum, lookup, maxifs minifs countifs, sumifs 9 Attachment(s)
    • 2,449
    Last Post: 11-12-2020 08:43 AM
    by JeteMc  Go to last post

    Forum:
    Excel Formulas & Functions

  31. [SOLVED] Get highest value based on two columns

    Started by Rehman5000‎, 11-05-2020 12:37 PM
    aggregate, highest, index, lookup, match 2 Attachment(s)
    • 574
    Last Post: 11-05-2020 01:57 PM
    by Rehman5000  Go to last post

    Forum:
    Excel Formulas & Functions

  32. Array Formulas with Multiple Range Criterias - not returning result

    Started by stearno‎, 11-05-2020 04:13 AM
    aggregate, filter, index/match, xlookup 1 Attachment(s)
    • 572
    Last Post: 11-10-2020 01:56 AM
    by BMV  Go to last post

    Forum:
    Excel Formulas & Functions

  33. Target Formula

    Started by uknusa‎, 09-20-2020 09:51 AM
    aggregate, sum, target 1 Attachment(s)
    • 661
    Last Post: 09-20-2020 09:54 AM
    by AliGW  Go to last post

    Forum:
    Excel Formulas & Functions

  34. Select specific rows from separate worksheets and import into master worksheet

    Started by shaunguyver‎, 09-07-2020 05:52 AM
    aggregate, vba 1 Attachment(s)
    • 483
    Last Post: 09-07-2020 08:13 AM
    by shaunguyver  Go to last post

    Forum:
    Excel Programming / VBA / Macros

  35. [SOLVED] Formula using Index, Aggregate, Row, Count, Sum, Sumif not giving correct sum of values

    Started by planjb‎, 07-22-2020 10:23 PM
    aggregate, count, formula, index, row 2 Attachment(s)
    • 1,274
    Last Post: 07-24-2020 08:09 AM
    by planjb  Go to last post

    Forum:
    Excel Formulas & Functions

Results 1 to 35 of 83
Page 1 of 3 1 2 3

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1