Search:

Tag: aggregate

Page 1 of 2 1 2

Search: Replies Views Search took 0.00 seconds.

  1. Match index formula not working

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

    Forum:
    Excel General

  2. A changing frequency table

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

    Forum:
    Excel Formulas & Functions

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

    Forum:
    Excel Formulas & Functions

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

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

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

    Forum:
    Excel Formulas & Functions

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

    Forum:
    Excel Charting & Pivots

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

    Forum:
    Excel General

  8. [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)
    • 512
    Last Post: 11-12-2020 08:43 AM
    by JeteMc  Go to last post

    Forum:
    Excel Formulas & Functions

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

    Forum:
    Excel Formulas & Functions

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

    Forum:
    Excel Formulas & Functions

  11. Target Formula

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

    Forum:
    Excel Formulas & Functions

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

    Forum:
    Excel Programming / VBA / Macros

  13. [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)
    • 456
    Last Post: 07-24-2020 08:09 AM
    by planjb  Go to last post

    Forum:
    Excel Formulas & Functions

  14. [SOLVED] rewrite aggregate function

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

    Forum:
    Excel Formulas & Functions

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

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

    Forum:
    Excel General

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

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

    Forum:
    Excel Formulas & Functions

  17. [SOLVED] Data sorting/filtering

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

    Forum:
    Excel Formulas & Functions

  18. Convert INDEX MATCH AGGREGATE FORMULA to VBA code

    Started by samuelkmh‎, 07-04-2019 08:53 PM
    aggregate, index, match, vba
    • 402
    Last Post: 07-05-2019 03:28 AM
    by samuelkmh  Go to last post

    Forum:
    Excel Programming / VBA / Macros

  19. Extract or filter Data

    Started by Cathrine Paul‎, 05-20-2019 06:09 PM
    aggregate, filter, match & index, small, vlookup 4 Attachment(s)
    • 328
    Last Post: 05-27-2019 09:01 AM
    by JeteMc  Go to last post

    Forum:
    Excel Formulas & Functions

  20. Extract Top 5 Values from each category

    Started by Cathrine Paul‎, 05-04-2019 04:11 PM
    aggregate, indedx, large, vlook up 2 Attachment(s)
    • 278
    Last Post: 05-20-2019 04:50 PM
    by Cathrine Paul  Go to last post

    Forum:
    Excel Formulas & Functions

  21. [SOLVED] Aggregate/lookup function works with numbers in array but stops when a word is retrieved

    Started by dsteele111‎, 03-22-2019 11:04 AM
    aggregate, function, lookup 6 Attachment(s)
    • 519
    Last Post: 03-22-2019 03:51 PM
    by dsteele111  Go to last post

    Forum:
    Excel Formulas & Functions

  22. Running Total: Not Sure Which Function to Use

    Started by thesuperman97‎, 12-12-2018 08:00 PM
    aggregate, running total, subtotal
    • 285
    Last Post: 12-12-2018 08:09 PM
    by Pete_UK  Go to last post

    Forum:
    Excel Formulas & Functions

  23. [SOLVED] AGGREGATE returns wrong results

    Started by JozefJ‎, 10-25-2018 05:56 AM
    aggregate, index, match, min 1 Attachment(s)
    • 1,000
    Last Post: 10-30-2018 03:40 PM
    by FlameRetired  Go to last post

    Forum:
    Excel Formulas & Functions

  24. Can someone please explain this set of functions?

    Started by tigerbanana‎, 09-26-2018 11:00 PM
    aggregate 1 Attachment(s)
    • 281
    Last Post: 10-03-2018 03:09 PM
    by JeteMc  Go to last post

    Forum:
    Excel Formulas & Functions

  25. [SOLVED] Find Unique values list updatable

    Started by Navi_G‎, 06-05-2018 03:45 PM
    aggregate, remove duplicate, unique, unique values from list
    • 433
    Last Post: 06-07-2018 03:37 AM
    by Navi_G  Go to last post

    Forum:
    Excel General

  26. How do I get data from daily reports into a master document based on filename and location

    Started by sp_key‎, 05-15-2018 06:02 AM
    aggregate, daily reports, filename, location path, master document 3 Attachment(s)
    • 386
    Last Post: 05-22-2018 08:58 AM
    by Olly  Go to last post

    Forum:
    Excel General

  27. [SOLVED] Aggregate with Average VS IF & ISERROR help

    Started by Shruder‎, 04-11-2018 02:51 PM
    aggregate, averageif, nested 3 Attachment(s)
    • 921
    Last Post: 04-12-2018 01:24 PM
    by Shruder  Go to last post

    Forum:
    Excel Formulas & Functions

  28. Aggregate function slowing down my file

    Started by porepiga‎, 01-17-2018 04:40 PM
    aggregate, errors, max, slow
    • 406
    Last Post: 01-17-2018 05:59 PM
    by daddylonglegs  Go to last post

    Forum:
    Excel General

  29. [SOLVED] Formula to find label for top five values using INDEX / AGGREGATE

    Started by heytherejem‎, 07-10-2017 05:28 AM
    aggregate, index, large function 1 Attachment(s)
    • 386
    Last Post: 07-10-2017 06:43 AM
    by heytherejem  Go to last post

    Forum:
    Excel Formulas & Functions

  30. find a recipe inside other recipes.

    Started by FrankC95‎, 07-04-2017 07:46 PM
    aggregate, array, index, lookup, match 1 Attachment(s)
    • 389
    Last Post: 07-05-2017 03:54 AM
    by FrankC95  Go to last post

    Forum:
    Excel Formulas & Functions

  31. Aggregate / group by within a chart

    Started by rjrcooper‎, 05-08-2017 05:01 PM
    aggregate, chart, group by 4 Attachment(s)
    • 783
    Last Post: 05-09-2017 02:43 PM
    by JeteMc  Go to last post

    Forum:
    Excel Charting & Pivots

  32. [SOLVED] VBA Aggregate Function

    Started by Gregor y‎, 02-24-2017 09:04 PM
    access 2013, aggregate, function declaration, vba 1 Attachment(s)
    • 3,103
    Last Post: 02-27-2017 03:17 AM
    by Keebellah  Go to last post

    Forum:
    Access Programming / VBA / Macros

  33. Aggregating Monthly Data

    Started by willie828‎, 11-30-2016 02:30 PM
    aggregate, pivot table 2 Attachment(s)
    • 559
    Last Post: 11-30-2016 04:54 PM
    by alansidman  Go to last post

    Forum:
    Excel General

  34. Combining multiple tables into one table

    Started by NDmad‎, 07-20-2016 02:19 PM
    aggregate, charts, combine, data, tables 1 Attachment(s)
    • 745
    Last Post: 07-20-2016 03:48 PM
    by Bernie Deitrick  Go to last post

    Forum:
    Excel General

  35. Aggregate Counta with criteria

    Started by cgampon‎, 06-28-2016 09:07 PM
    aggregate, counta
    • 1,185
    Last Post: 06-28-2016 10:52 PM
    by Jonmo1  Go to last post

    Forum:
    Excel Formulas & Functions

Results 1 to 35 of 61
Page 1 of 2 1 2

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1