I live in Germany and I did not understand anything I was looking for from the German tutorials on this Excel Agreegate command, but your tutorial was very clear. Thank you
Grate video I need your help, How to use aggregate function to extract large 3 numbers, To same first name in a cell, and how many this number repeated,
There is a video that instructs to find multiple conditions (2 or 3 or more conditions), returns many results shown on 1 column, or 1 row. I have only been able to do one condition detection now
Hi broncokeeper, you could use the Aggregate with either the Large or Max function for this example. First the date list would need to be filtered to show just the Compaq Notebooks. Then with the Aggregate function, you would choose either Max or Large, Ignore Hidden Rows, and apply to whatever range desired. If you want to find the largest number for that filtered list, the subtotal option would also work using the Max Function. Hope this helps.
![Seungmin "그렇게, 천천히, 우리(As we are)" | [Stray Kids : SKZ-PLAYER]](http://i.ytimg.com/vi/kAzmhLHePqU/mqdefault.jpg)
I live in Germany and I did not understand anything I was looking for from the German tutorials on this Excel Agreegate command, but your tutorial was very clear. Thank you
Grate video
I need your help,
How to use aggregate function to extract large 3 numbers, To same first name in a cell, and how many this number repeated,
There is a video that instructs to find multiple conditions (2 or 3 or more conditions), returns many results shown on 1 column, or 1 row. I have only been able to do one condition detection now
Very good video - sharp and to the point!
What are the advantages and disadvantages of aggregate tables?
Thank you for your clear and useful clip. Please make more for other arguments and options of this function.
What if I want to know the largest for Compaq, Notebook only. Can you do that with Aggregrate?
Hi broncokeeper, you could use the Aggregate with either the Large or Max function for this example. First the date list would need to be filtered to show just the Compaq Notebooks. Then with the Aggregate function, you would choose either Max or Large, Ignore Hidden Rows, and apply to whatever range desired. If you want to find the largest number for that filtered list, the subtotal option would also work using the Max Function. Hope this helps.
LogOnToLearn Big help. Thanks!
Thanks! Really well understood..
Thank you very useful
Thank you.
Thanks