Hi Dave, Thank you for putting these videos out, they been helping me out for my internship. I do have a problem with the maxifs calculation. When I do the calculation -> =maxifs(index(Data,,match("Date", Headers,)), index(Data,,match("Date", Headers,)), "
Hi there, Thank you so much for putting these videos out here. I actually just finished up the dashboard and there are a couple of things I was wanting to change. I was wondering if you would be able to help me with a couple of questions I have. 1. In the TestSetUp tab I was wondering if it is possible to pull the min and max data from the current test date selected instead of the entire data set. 2. Is there another formula that can be used to pull a selected test date instead of the latest test date from the radar graph? Thanks again!
Hi Dave, I've had a bit of a problem with both maxifs and minifs regarding dates. They both show 12/30/1899. I'm a little unsure how to get these to populate the date from my datasheet. These make both the radar and trends unusable. Any Help would be much appreciated! Loving the content you're putting out!
Hi Tommy, Thanks for checking out the videos.. I believe they will show that when your dates are not formatted correctly or you are referring to a date that is not in the range.
@@DSMStrength Honestly your videos are the greatest thing on the data side of S&C RUclips. You have such a talent and I am just one of many who owe you for the immense generosity you continue to display. I had the same issue using UK date format (dd-mm-yyyy), but if you go to the spreadsheet settings and change local it sorts it.
Hi All, I am having the same issue after using the MAXIFS function. It is returning 12/30/1899. Tried the change local in settings but hasn't fixed it. Has anyone experienced this and been able to resolve the issue? Absolutely love the videos DSM Strength - thank you!
@@DSMStrength Hi Dave, I'm having the same problem and I am confused by the answer here. Any help greatly appreciated. Basically I don't know which one has more or less than the other, cheers
Hi Dave, I was wondering how the below function might work in Microsoft excel? It comes up with the value I need for one test but then won't allow me to change for the others. It is the section Standard formula which excel seems to get stuck. Any help would be great.
hi jordan im not sure, I have never tried to re-create this in excel. part of the reason I use google sheet is because there are so many versions of excel
keep it going Dave! Great stuff
Thanks man we're almost there
Hi Dave,
Thank you for putting these videos out, they been helping me out for my internship. I do have a problem with the maxifs calculation.
When I do the calculation -> =maxifs(index(Data,,match("Date", Headers,)), index(Data,,match("Date", Headers,)), "
Hi Enzo, were you able to figure out the reason for this? Thank you
I have this exact same problem? Has anyone got a solution?
How would you restructure this formula @19:56 It gives me a spill in Excel, but does not properly match up with the table
The formula I show is for Google sheets the same type of formula will not work in excel
Niiiiice
Thanks for checking it out!! Hope it helps
Hi there,
Thank you so much for putting these videos out here. I actually just finished up the dashboard and there are a couple of things I was wanting to change. I was wondering if you would be able to help me with a couple of questions I have.
1. In the TestSetUp tab I was wondering if it is possible to pull the min and max data from the current test date selected instead of the entire data set.
2. Is there another formula that can be used to pull a selected test date instead of the latest test date from the radar graph?
Thanks again!
yes both of those are possible
Hi Dave, I've had a bit of a problem with both maxifs and minifs regarding dates. They both show 12/30/1899. I'm a little unsure how to get these to populate the date from my datasheet. These make both the radar and trends unusable. Any Help would be much appreciated! Loving the content you're putting out!
Hi Tommy,
Thanks for checking out the videos.. I believe they will show that when your dates are not formatted correctly or you are referring to a date that is not in the range.
@@DSMStrength Honestly your videos are the greatest thing on the data side of S&C RUclips. You have such a talent and I am just one of many who owe you for the immense generosity you continue to display. I had the same issue using UK date format (dd-mm-yyyy), but if you go to the spreadsheet settings and change local it sorts it.
Hi All, I am having the same issue after using the MAXIFS function. It is returning 12/30/1899. Tried the change local in settings but hasn't fixed it. Has anyone experienced this and been able to resolve the issue? Absolutely love the videos DSM Strength - thank you!
@@oliverhunt3291 Try to change the cell properties in data, It works for me.
@@robje1402 What did you change? I've tried everything thats been mentioned and I'm still having trouble
Dave, could you help me fix a #value! error. It says "Array arguments to maxifs are of different size". This only happens on of my KPI metrics.
means you are trying to return something that has a different amount of values then what your criteria is or vice versa.. they have to be the same
@@DSMStrength Hi Dave, I'm having the same problem and I am confused by the answer here. Any help greatly appreciated. Basically I don't know which one has more or less than the other, cheers
👍🏼👍🏼
Thank you
Hi Dave, I was wondering how the below function might work in Microsoft excel? It comes up with the value I need for one test but then won't allow me to change for the others. It is the section Standard formula which excel seems to get stuck. Any help would be great.
=IFERROR(FILTER(INDEX(TBLDATA,,MATCH(AK33,Headers,)), INDEX(TBLDATA,,MATCH("Athlete name", Headers,))=$AL$22, INDEX(TBLDATA,,MATCH("date",Headers,))=AL33),"")
hi jordan im not sure, I have never tried to re-create this in excel.
part of the reason I use google sheet is because there are so many versions of excel
in this video the formula =iferror(around(ac3........ doesn't seem to work. The radar doest update. Any suggestions?
Mround not around
@@DSMStrength sorry about the typo. the radar doesn't update.
=iferror(mround((AC3-AA3)/(AB3-AA3)*100, 0.5), ""):
=iferror(mround((AA13-AA3)/(AB3-AA3)*100, 0.5), "")
I tried these but no results
@@varunghosh2384 are all of your ranges set up correctly?
@@DSMStrength what ranges are you referring to? I think I'm having the same issue.