Search:

Tag: aggregate

Page 1 of 2 1 2

Search: Replies Views Search took 0.00 seconds.

  1. [SOLVED] Subtotal/Aggregate Not Working Help

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

    Forum:
    Excel Formulas & Functions

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

    Forum:
    Excel Formulas & Functions

  3. Prevent certain input from appearing in a range

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

    Forum:
    Excel General

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

    Forum:
    Excel Formulas & Functions

  5. Aggregate statistics across multiple sheets if multiple critereon met

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

    Forum:
    Excel Formulas & Functions

  6. 1 value and return multiple results

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

    Forum:
    Excel Formulas & Functions

  7. Match index formula not working

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

    Forum:
    Excel General

  8. A changing frequency table

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

    Forum:
    Excel Formulas & Functions

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

    Forum:
    Excel Formulas & Functions

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

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

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

    Forum:
    Excel Formulas & Functions

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

    Forum:
    Excel Charting & Pivots

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

    Forum:
    Excel General

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

    Forum:
    Excel Formulas & Functions

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

    Forum:
    Excel Formulas & Functions

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

    Forum:
    Excel Formulas & Functions

  17. Target Formula

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

    Forum:
    Excel Formulas & Functions

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

    Forum:
    Excel Programming / VBA / Macros

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

    Forum:
    Excel Formulas & Functions

  20. [SOLVED] rewrite aggregate function

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

    Forum:
    Excel Formulas & Functions

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

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

    Forum:
    Excel General

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

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

    Forum:
    Excel Formulas & Functions

  23. [SOLVED] Data sorting/filtering

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

    Forum:
    Excel Formulas & Functions

  24. Convert INDEX MATCH AGGREGATE FORMULA to VBA code

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

    Forum:
    Excel Programming / VBA / Macros

  25. Extract or filter Data

    Started by Cathrine Paul‎, 05-20-2019 06:09 PM
    aggregate, filter, match & index, small, vlookup 6 Attachment(s)
    • 663
    Last Post: 10-01-2021 11:37 AM
    by AliGW  Go to last post

    Forum:
    Excel Formulas & Functions

  26. 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)
    • 375
    Last Post: 05-20-2019 04:50 PM
    by Cathrine Paul  Go to last post

    Forum:
    Excel Formulas & Functions

  27. [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)
    • 651
    Last Post: 03-22-2019 03:51 PM
    by dsteele111  Go to last post

    Forum:
    Excel Formulas & Functions

  28. Running Total: Not Sure Which Function to Use

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

    Forum:
    Excel Formulas & Functions

  29. [SOLVED] AGGREGATE returns wrong results

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

    Forum:
    Excel Formulas & Functions

  30. Can someone please explain this set of functions?

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

    Forum:
    Excel Formulas & Functions

  31. [SOLVED] Find Unique values list updatable

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

    Forum:
    Excel General

  32. 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)
    • 469
    Last Post: 05-22-2018 08:58 AM
    by Olly  Go to last post

    Forum:
    Excel General

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

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

    Forum:
    Excel Formulas & Functions

  34. Aggregate function slowing down my file

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

    Forum:
    Excel General

  35. [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)
    • 473
    Last Post: 07-10-2017 06:43 AM
    by heytherejem  Go to last post

    Forum:
    Excel Formulas & Functions

Results 1 to 35 of 67
Page 1 of 2 1 2

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1