# Search:

Tag: aggregate

Page 1 of 2 1

## Search: Replies Views Search took 0.00 seconds.

1. ### [SOLVED] Subtotal/Aggregate Not Working Help

• 165
Last Post: 01-10-2023 05:19 PM
by Croweater
2. ### match partial or complete text and match in another column to extract index value

• 222
Last Post: 11-26-2022 04:58 PM
by MarvinP
3. ### Prevent certain input from appearing in a range

• 199
Last Post: 09-27-2022 02:28 AM
by Jude_Long
4. ### Optimizing the Formula to run faster Finding the latest record

• 253
Last Post: 04-19-2022 07:35 AM
by zaveed
5. ### Aggregate statistics across multiple sheets if multiple critereon met

• 193
Last Post: 03-09-2022 12:40 PM
by Richard Buttrey
6. ### 1 value and return multiple results

• 253
Last Post: 02-11-2022 08:58 AM
by AliGW
7. ### Match index formula not working

• 306
Last Post: 07-29-2021 10:40 PM
by josephteh
8. ### A changing frequency table

• 320
Last Post: 06-09-2021 10:28 AM
by CPILon
9. ### Displaying data from multiple sheets with multiple criteria

• 295
Last Post: 05-03-2021 08:23 PM
by thenewkidd
10. ### How to convert excel aggregation/consolidation to google sheets

• 341
Last Post: 02-18-2021 08:40 AM
by Glenn Kennedy
11. ### [SOLVED] Create an advanced report to show average price per brand (sorted by country+ cat of item)

• 512
Last Post: 12-14-2020 05:52 AM
by Keebellah
12. ### Aggregate PIVOT TABLE with custom Cumulative Product formula

• 501
Last Post: 11-24-2020 12:55 AM
by bebo021999
13. ### [SOLVED] Creating an Array formula which calculates depending on what is filtered

• 459
Last Post: 11-16-2020 10:18 AM
by JeteMc
14. ### [SOLVED] Calculate cumulative sums and obtain highest value based on it

• 894
Last Post: 11-12-2020 08:43 AM
by JeteMc
15. ### [SOLVED] Get highest value based on two columns

• 302
Last Post: 11-05-2020 01:57 PM
by Rehman5000
16. ### Array Formulas with Multiple Range Criterias - not returning result

• 286
Last Post: 11-10-2020 01:56 AM
by BMV
17. ### Target Formula

• 276
Last Post: 09-20-2020 09:54 AM
by AliGW
18. ### Select specific rows from separate worksheets and import into master worksheet

• 231
Last Post: 09-07-2020 08:13 AM
by shaunguyver
19. ### [SOLVED] Formula using Index, Aggregate, Row, Count, Sum, Sumif not giving correct sum of values

• 738
Last Post: 07-24-2020 08:09 AM
by planjb
20. ### [SOLVED] rewrite aggregate function

• 297
Last Post: 07-09-2020 04:01 PM
by Fluff13

• 777
Last Post: 10-24-2019 02:30 PM
by JeteMc
22. ### [SOLVED] Percentile with multiple conditions from data in another sheet

• 1,368
Last Post: 09-27-2019 12:23 PM
by Glenn Kennedy
23. ### [SOLVED] Data sorting/filtering

• 604
Last Post: 07-25-2019 04:19 AM
by AliGW
24. ### Convert INDEX MATCH AGGREGATE FORMULA to VBA code

• 602
Last Post: 07-05-2019 03:28 AM
by samuelkmh
25. ### Extract or filter Data

• 663
Last Post: 10-01-2021 11:37 AM
by AliGW
26. ### Extract Top 5 Values from each category

• 375
Last Post: 05-20-2019 04:50 PM
by Cathrine Paul
27. ### [SOLVED] Aggregate/lookup function works with numbers in array but stops when a word is retrieved

• 651
Last Post: 03-22-2019 03:51 PM
by dsteele111
28. ### Running Total: Not Sure Which Function to Use

• 381
Last Post: 12-12-2018 08:09 PM
by Pete_UK
29. ### [SOLVED] AGGREGATE returns wrong results

• 1,337
Last Post: 10-30-2018 03:40 PM
by FlameRetired
30. ### Can someone please explain this set of functions?

• 347
Last Post: 10-03-2018 03:09 PM
by JeteMc
31. ### [SOLVED] Find Unique values list updatable

• 587
Last Post: 06-07-2018 03:37 AM
by Navi_G
32. ### How do I get data from daily reports into a master document based on filename and location

• 469
Last Post: 05-22-2018 08:58 AM
by Olly
33. ### [SOLVED] Aggregate with Average VS IF & ISERROR help

• 1,291
Last Post: 04-12-2018 01:24 PM
by Shruder
34. ### Aggregate function slowing down my file

• 541
Last Post: 01-17-2018 05:59 PM