I am retired and a spreadsheet fanatic, but what little I learned about functions 40 yrs ago, I had no memory of. I don't make them for anything important but I just love to make them, redo them and perfect them. I make them for all sorts of things. I decided I wanted to make my current blood pressure chart with formulas to average my daily blood pressure readings for me. I wanted weekly averages & a monthly average..all the stuff that takes me so much time at the end of each month. I don't know how many websites and videos I looked through before I found this one, and finally...my problem with the errors I was getting with the monthly average was solved! Thank you so much!
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,
You would need a combination of functions for this Azeez beyond the scope of this comment box. It sounds like you are asking for two columns returned also - top 3 numbers, and number of occurrences. I perform a similar task in this video th-cam.com/video/sk3z8e2mvng/w-d-xo.html which I mention because it shows COUNTIFS too. I have other videos doing similar tasks if you search my channel for LARGE and Top N.
Love your videos and really appreciate you doing these. I'm using the Aggregate function on a column with values derived by formulas (calculated column?). It's not summing correctly when I hide rows (in fact, it increases; doesn't even decrease properly, though I don't want it to decrease. I want the entire column sum regardless of which rows are hidden). I went ahead and tried Sumproduct also but it's not working either. For some reason, it seems nobody explains this well. I can't find a solution anywhere. Any idea why it's not working correctly and, if so, do you know any possible work-arounds?
I am retired and a spreadsheet fanatic, but what little I learned about functions 40 yrs ago, I had no memory of. I don't make them for anything important but I just love to make them, redo them and perfect them. I make them for all sorts of things. I decided I wanted to make my current blood pressure chart with formulas to average my daily blood pressure readings for me. I wanted weekly averages & a monthly average..all the stuff that takes me so much time at the end of each month. I don't know how many websites and videos I looked through before I found this one, and finally...my problem with the errors I was getting with the monthly average was solved! Thank you so much!
Awesome!! You're very welcome, Susan. Thank you for your comments.
Thank you for the concise tutorial.
You're welcome!
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,
You would need a combination of functions for this Azeez beyond the scope of this comment box. It sounds like you are asking for two columns returned also - top 3 numbers, and number of occurrences.
I perform a similar task in this video th-cam.com/video/sk3z8e2mvng/w-d-xo.html which I mention because it shows COUNTIFS too. I have other videos doing similar tasks if you search my channel for LARGE and Top N.
Great Teaching...
Thanks Irshad
you are welcome Sir
Love your videos and really appreciate you doing these. I'm using the Aggregate function on a column with values derived by formulas (calculated column?). It's not summing correctly when I hide rows (in fact, it increases; doesn't even decrease properly, though I don't want it to decrease. I want the entire column sum regardless of which rows are hidden). I went ahead and tried Sumproduct also but it's not working either. For some reason, it seems nobody explains this well. I can't find a solution anywhere. Any idea why it's not working correctly and, if so, do you know any possible work-arounds?
I would have to see it Chris. I can't think of why this would increase.