Search:

Tag: aggregate

Page 1 of 3 1 2 3

Search: Replies Views Search took 0.00 seconds; generated 10 minute(s) ago.

  1. Create Formula to show for filtered tick boxes

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

    Forum:
    Excel Formulas & Functions

  2. 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)
    • 245
    Last Post: 01-17-2025 10:20 PM
    by protonLeah  Go to last post

    Forum:
    Excel Charting & Pivots

  3. [SOLVED] MINIFS and hidden data

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

    Forum:
    Excel Formulas & Functions

  4. [SOLVED] INDIRECT ADDRESS #REF error

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

    Forum:
    Excel Formulas & Functions

  5. [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)
    • 309
    Last Post: 08-26-2024 07:37 AM
    by B.W.B.  Go to last post

    Forum:
    Excel Formulas & Functions

  6. [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)
    • 378
    Last Post: 08-22-2024 10:00 AM
    by romperstomper  Go to last post

    Forum:
    Excel Formulas & Functions

  7. [SOLVED] Need second smallest/largest.

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

    Forum:
    Excel Formulas & Functions

  8. 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)
    • 542
    Last Post: 10-03-2023 06:52 AM
    by Czeslaw  Go to last post

    Forum:
    Excel Formulas & Functions

  9. Aggregate of Multiple columns IF a condition is met

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

    Forum:
    Excel Formulas & Functions

  10. 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)
    • 272
    Last Post: 06-05-2023 12:28 PM
    by AliGW  Go to last post

    Forum:
    Excel Formulas & Functions

  11. Power Query Multiplying Aggregated field

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

    Forum:
    Office 365

  12. [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)
    • 463
    Last Post: 04-03-2023 12:21 PM
    by windknife  Go to last post

    Forum:
    Excel Formulas & Functions

  13. [SOLVED] Subtotal/Aggregate Not Working Help

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

    Forum:
    Excel Formulas & Functions

  14. 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)
    • 674
    Last Post: 11-26-2022 04:58 PM
    by MarvinP  Go to last post

    Forum:
    Excel Formulas & Functions

  15. Prevent certain input from appearing in a range

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

    Forum:
    Excel General

  16. 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)
    • 614
    Last Post: 04-19-2022 07:35 AM
    by zaveed  Go to last post

    Forum:
    Excel Formulas & Functions

  17. Aggregate statistics across multiple sheets if multiple critereon met

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

    Forum:
    Excel Formulas & Functions

  18. 1 value and return multiple results

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

    Forum:
    Excel Formulas & Functions

  19. Match index formula not working

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

    Forum:
    Excel General

  20. A changing frequency table

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

    Forum:
    Excel Formulas & Functions

  21. 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)
    • 482
    Last Post: 05-03-2021 08:23 PM
    by thenewkidd  Go to last post

    Forum:
    Excel Formulas & Functions

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

    Started by ISH1959‎, 02-18-2021 08:36 AM
    aggregate, conolidate, sheetrange
    • 674
    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)

  23. [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)
    • 705
    Last Post: 12-14-2020 05:52 AM
    by Keebellah  Go to last post

    Forum:
    Excel Formulas & Functions

  24. 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)
    • 812
    Last Post: 11-24-2020 12:55 AM
    by bebo021999  Go to last post

    Forum:
    Excel Charting & Pivots

  25. [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
    • 710
    Last Post: 11-16-2020 10:18 AM
    by JeteMc  Go to last post

    Forum:
    Excel General

  26. [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,242
    Last Post: 11-12-2020 08:43 AM
    by JeteMc  Go to last post

    Forum:
    Excel Formulas & Functions

  27. [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)
    • 502
    Last Post: 11-05-2020 01:57 PM
    by Rehman5000  Go to last post

    Forum:
    Excel Formulas & Functions

  28. 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)
    • 504
    Last Post: 11-10-2020 01:56 AM
    by BMV  Go to last post

    Forum:
    Excel Formulas & Functions

  29. Target Formula

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

    Forum:
    Excel Formulas & Functions

  30. 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)
    • 423
    Last Post: 09-07-2020 08:13 AM
    by shaunguyver  Go to last post

    Forum:
    Excel Programming / VBA / Macros

  31. [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,176
    Last Post: 07-24-2020 08:09 AM
    by planjb  Go to last post

    Forum:
    Excel Formulas & Functions

  32. [SOLVED] rewrite aggregate function

    Started by Eastw00d‎, 07-09-2020 03:27 PM
    aggregate, index & aggregate 1 Attachment(s)
    • 530
    Last Post: 07-09-2020 04:01 PM
    by Fluff13  Go to last post

    Forum:
    Excel Formulas & Functions

  33. [SOLVED] Please help Combine Lists and Flatten Data

    Started by Baltimorejack68‎, 10-18-2019 05:11 PM
    aggregate, combine, flatten, flattening 2 Attachment(s)
    • 1,015
    Last Post: 10-24-2019 02:30 PM
    by JeteMc  Go to last post

    Forum:
    Excel General

  34. [SOLVED] Percentile with multiple conditions from data in another sheet

    Started by ferguson9‎, 09-26-2019 11:46 AM
    aggregate, formula array, percentile
    • 2,647
    Last Post: 09-27-2019 12:23 PM
    by Glenn Kennedy  Go to last post

    Forum:
    Excel Formulas & Functions

  35. [SOLVED] Data sorting/filtering

    Started by KylieD‎, 07-16-2019 08:57 AM
    aggregate, array, convert, filter, if(and) 3 Attachment(s)
    • 884
    Last Post: 07-25-2019 04:19 AM
    by AliGW  Go to last post

    Forum:
    Excel Formulas & Functions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1