Search:

Tag: aggregate

Page 1 of 3 1 2 3

Search: Replies Views Search took 0.00 seconds.

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

    Forum:
    Excel Formulas & Functions

  2. Aggregate of Multiple columns IF a condition is met

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

    Forum:
    Excel Formulas & Functions

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

    Forum:
    Excel Formulas & Functions

  4. Power Query Multiplying Aggregated field

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

    Forum:
    Office 365

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

    Forum:
    Excel Formulas & Functions

  6. [SOLVED] Subtotal/Aggregate Not Working Help

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

    Forum:
    Excel Formulas & Functions

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

    Forum:
    Excel Formulas & Functions

  8. Prevent certain input from appearing in a range

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

    Forum:
    Excel General

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

    Forum:
    Excel Formulas & Functions

  10. Aggregate statistics across multiple sheets if multiple critereon met

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

    Forum:
    Excel Formulas & Functions

  11. 1 value and return multiple results

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

    Forum:
    Excel Formulas & Functions

  12. Match index formula not working

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

    Forum:
    Excel General

  13. A changing frequency table

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

    Forum:
    Excel Formulas & Functions

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

    Forum:
    Excel Formulas & Functions

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

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

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

    Forum:
    Excel Formulas & Functions

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

    Forum:
    Excel Charting & Pivots

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

    Forum:
    Excel General

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

    Forum:
    Excel Formulas & Functions

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

    Forum:
    Excel Formulas & Functions

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

    Forum:
    Excel Formulas & Functions

  22. Target Formula

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

    Forum:
    Excel Formulas & Functions

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

    Forum:
    Excel Programming / VBA / Macros

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

    Forum:
    Excel Formulas & Functions

  25. [SOLVED] rewrite aggregate function

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

    Forum:
    Excel Formulas & Functions

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

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

    Forum:
    Excel General

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

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

    Forum:
    Excel Formulas & Functions

  28. [SOLVED] Data sorting/filtering

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

    Forum:
    Excel Formulas & Functions

  29. Convert INDEX MATCH AGGREGATE FORMULA to VBA code

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

    Forum:
    Excel Programming / VBA / Macros

  30. Extract or filter Data

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

    Forum:
    Excel Formulas & Functions

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

    Forum:
    Excel Formulas & Functions

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

    Forum:
    Excel Formulas & Functions

  33. Running Total: Not Sure Which Function to Use

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

    Forum:
    Excel Formulas & Functions

  34. [SOLVED] AGGREGATE returns wrong results

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

    Forum:
    Excel Formulas & Functions

  35. Can someone please explain this set of functions?

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

    Forum:
    Excel Formulas & Functions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1