Top 10 Most Important Intermediate Excel Functions - My Online Training Hub
video description
Date: 2022-04-08
Related videos
Comments and reviews: 10
Emre
Thank you Mynda for this handy tutorial.
Although XLook up is running exactly to find values from the range, it is not spilled for dublicate values in a range like;
--apple-, -orrange-, -banana-, -apple-- -10, 5, 20, 15- - - it returns just 10 not 15. I think it must be improved to be returned results regarding dublicate values in same range.
And
I would like to learn what the differences between Getpivotdata and Cube formulas are?
Thank you
reply
Thank you Mynda for this handy tutorial.
Although XLook up is running exactly to find values from the range, it is not spilled for dublicate values in a range like;
--apple-, -orrange-, -banana-, -apple-- -10, 5, 20, 15- - - it returns just 10 not 15. I think it must be improved to be returned results regarding dublicate values in same range.
And
I would like to learn what the differences between Getpivotdata and Cube formulas are?
Thank you
reply
Overdraft
Hi Mynda! Thanks for this! And as usual, there was an easter egg in there... or part of one... that had nothing to do with the actual theme! You were building a formula and referencing a cell that was buried under the formula building dialog and you clicked a cell in the desired column a row or two below and then somehow moved it up to the correct row that was under the dialog... how did you get it to move?
reply
Hi Mynda! Thanks for this! And as usual, there was an easter egg in there... or part of one... that had nothing to do with the actual theme! You were building a formula and referencing a cell that was buried under the formula building dialog and you clicked a cell in the desired column a row or two below and then somehow moved it up to the correct row that was under the dialog... how did you get it to move?
reply
tb3420
Trivial, but XLOOKUP looks to me like an improved version of LOOKUP (in the same way XMATCH is an updated MATCH) - the syntax of the first three arguments is exactly the same as LOOKUP. VLOOKUP syntax is quite different (and loathsome IMO!).
Funny thing is I have seen people using IFERROR with XLOOKUP a fair bit.
reply
Trivial, but XLOOKUP looks to me like an improved version of LOOKUP (in the same way XMATCH is an updated MATCH) - the syntax of the first three arguments is exactly the same as LOOKUP. VLOOKUP syntax is quite different (and loathsome IMO!).
Funny thing is I have seen people using IFERROR with XLOOKUP a fair bit.
reply
John
I discovered that the VLOOKUP between 2 workbooks is fine if both files on locally stored. However, when both workbooks are in the OneDrive folder the VLOOKUP does not appear to work in the same manner. I'm not sure if you are able to recreate this and do a video on how users are able to correct the problem.
reply
I discovered that the VLOOKUP between 2 workbooks is fine if both files on locally stored. However, when both workbooks are in the OneDrive folder the VLOOKUP does not appear to work in the same manner. I'm not sure if you are able to recreate this and do a video on how users are able to correct the problem.
reply
Roger
5:24 For logical AND() and OR() prefer the mathematical notation, that's easier for huge number of conditions: see examples below:
AND() => =IF(([-Popular]=-Yes-)-([-[Salary $k]] =IF(([-Popular]=-Yes-)+([-[Salary $k]]
reply
5:24 For logical AND() and OR() prefer the mathematical notation, that's easier for huge number of conditions: see examples below:
AND() => =IF(([-Popular]=-Yes-)-([-[Salary $k]] =IF(([-Popular]=-Yes-)+([-[Salary $k]]
reply
Jim
Great tutorial, Mynda! Thanks. I regularly use most of these. Exceptions are AGGREGATE (which I basically ignored until now) & GETPIVOTDATA (which I-m using increasingly since you released that tutorial).
reply
Great tutorial, Mynda! Thanks. I regularly use most of these. Exceptions are AGGREGATE (which I basically ignored until now) & GETPIVOTDATA (which I-m using increasingly since you released that tutorial).
reply
Arya
Bwaha I completely forgot about Ben 10. He used to be my sister-s cartoon crush. Great tutorial, currently on maternity leave so it-s nice to recap all the popular functions from time to time. Xx
reply
Bwaha I completely forgot about Ben 10. He used to be my sister-s cartoon crush. Great tutorial, currently on maternity leave so it-s nice to recap all the popular functions from time to time. Xx
reply
Vijay
Thank you Mynda for this super useful video! I have been using most of them regularly, but found a lot of value addition and ideas through your examples! Keep up the great work! --
reply
Thank you Mynda for this super useful video! I have been using most of them regularly, but found a lot of value addition and ideas through your examples! Keep up the great work! --
reply
Dale
What a great tutorial and thanks for the accompanying file and references to additional tutorials. You are doing a great job. Thank you for all the help you are providing. Super!!
reply
What a great tutorial and thanks for the accompanying file and references to additional tutorials. You are doing a great job. Thank you for all the help you are providing. Super!!
reply
Parahi
I find writing pseudo code beforehand helps structure the formula and makes it easier to write. Really good tutorial on how to use these functions. Thanks!
reply
I find writing pseudo code beforehand helps structure the formula and makes it easier to write. Really good tutorial on how to use these functions. Thanks!
reply
Add a review, comment
Other channel videos
