thank you. very usefull. Do you know that we can use the XLOOKUP function to retrieve cell adress? like sum(xlookup(......):xlookup(.......)) it works as same as INDEX function
Thanks ! The two way lookup works only where you have one criteria in a row and one criteria in columns ? how it works if both criteria are in columns ?
Thanks for all amazing training videos, short, sweet and right to the point but very through! Would you kindly let me know how I can use XLOOKUP up to search for the number of rows with a field includes certain value for This and/ or Last Week, This and/ or Last Month, This and/ or Last Quarter and This and/ or Last Year? How would the formula could look? Do you know a better solution without NO VBA? Thank you!
Approximate Match - do you have an example showing hoe to use a column of data. i.e. you have scores for 1K students and want to provide them an Alpha score. to complicate things - Might need to grade on a curve after discovering no one got an "A" ☺
Very good. I did know this but I liked your presentation style and recommend others to follow you.
Thanks Duncan!
Great examples - love the timeline links
Quick QUESTION: How do you show the formula in the adjacent cell in your videos.
Use the formula--> Iferror(Formulatext(Cell with Formula),"Not found")
Very good..and thanks
Hey John, your website links to get the workbook and subscribe are doing nothing when clicked! Love your stuff!
thank you. very usefull.
Do you know that we can use the XLOOKUP function to retrieve cell adress?
like sum(xlookup(......):xlookup(.......))
it works as same as INDEX function
Yes, that's a good tip!
There a couple other functions like that, but I don't know the complete list.
Another great video!
مرسی
Thanks ! The two way lookup works only where you have one criteria in a row and one criteria in columns ? how it works if both criteria are in columns ?
Thanks for all amazing training videos, short, sweet and right to the point but very through! Would you kindly let me know how I can use XLOOKUP up to search for the number of rows with a field includes certain value for This and/ or Last Week, This and/ or Last Month, This and/ or Last Quarter and This and/ or Last Year? How would the formula could look? Do you know a better solution without NO VBA? Thank you!
Benedict look alike
Not the first time I've heard that 🤔
How do I get rid of zeros that populate in empty cells when I use the Xlookup function? Iferror isn't working for it for some reason.
Approximate Match - do you have an example showing hoe to use a column of data.
i.e. you have scores for 1K students and want to provide them an Alpha score.
to complicate things - Might need to grade on a curve after discovering no one got an "A" ☺
Fills in the required details. Receives approval, but it is not possible or not possible to download the file for practice and / or the book. Too bad.
Check your junk folder for the email with download details.
Bad explanation in the case search binary.
Feel free to do a better job.
dead nothing works can get downloads or books or anything UNSUBSCRIBED