Hi Alan.. super useful and super powerful technique for combining tables.. quick simple and updateable.. excellent! Thanks for sharing your know how. Thumbs up!
Great video as always, very clear thank you ! Do you happen to know a way to display the current workbook *sheets* in the same way Excel.CurrentWorkbook () shows *tables* ?
If you do not mind Alan, I have a question regarding the function Indirect. I have named ranges for instance Overhead and Travel Expenses on a worksheet. Let us assume that the Word Overhead is in Cell A5. When I go to E4 and I type =Sum(indirect(A5)) it works just fine. If I replace the word overhead with travel expenses, the formula does not work because of the space between the two words. I do not know how to solve this problem. I do not refer to another sheet. I would be grateful for help. Thanks in advance..
That is unfair Marcus. The video shows filtering out the unnecessary tables to prevent that issue. No data is mixed up. I demo refreshing it in the video.
Great video, exactly what I was looking for; have never used Power Query but this made it SO CLEAR AND EASY! Thank you so much!!!!
You're very welcome, Karen.
Great video. Thanks for this
No problem 👍 Thank you, Ian.
Whatever I m in search, getting a solution from here, Thanks for sharing, keep it up.
You're welcome. Thank you very much.
Another plus at 73 I'm still amazed.
Excellent, thank you, very clear concise solved the challenge :)
Thank you very much Steve.
So clear and useful, thanks!!
Great! You're very welcome, Federica.
Brilliantly simple to follow. Thank you.
You're very welcome. Thank you Luda.
As always: Cear, simple and to the point! Thanx very much!
Thank you very much Henk.
Hi Alan.. super useful and super powerful technique for combining tables.. quick simple and updateable.. excellent! Thanks for sharing your know how. Thumbs up!
My pleasure Wayne. Thank you.
Excellent presentation. Really helpful. Thanks.
Thank you Anill.
Excellent as usual.. 🌟 🌟 Thanks Alan. 👍 Power Query drives crazy with its power..
Thank you Salim. It certainly does.
Great tutorial as always, many thanks Alan. Cheers Mohideen
Always welcome my friend. Thank you Mohideen.
Thanks, this very helpful for my work.
Excellent! My pleasure Niti.
Great video, very informative. Thank you so much!
You're very welcome.
Great video as always, very clear thank you ! Do you happen to know a way to display the current workbook *sheets* in the same way Excel.CurrentWorkbook () shows *tables* ?
good job
Thank you Akash.
useful!
Thank you Steven.
If you do not mind Alan, I have a question regarding the function Indirect. I have named ranges for instance Overhead and Travel Expenses on a worksheet. Let us assume that the Word Overhead is in Cell A5. When I go to E4 and I type =Sum(indirect(A5)) it works just fine. If I replace the word overhead with travel expenses, the formula does not work because of the space between the two words. I do not know how to solve this problem. I do not refer to another sheet. I would be grateful for help. Thanks in advance..
Watch Alan's video on Indirect formula. You will see there that you can use Substitute function.
Dear Sir,
Can you plz provide the practice File ????
Sorry, these files are not available.
Dear Alan, alphanumeric number does not get captured, please suggest a work around.
Alphanumeric number not captured?
@@Computergaga yes, it does not reflect. In power query.
Please provide excel data sheet
alan i sent a mail to you.did you seen...regarding combined if(indirect(concatenate(match() function
I have seen it come in Vijay, but have not looked at it yet.
Computergaga alan I've tried but couldn't complete.awaiting for your video or reply
Does not work as it mixes up data and multiplies it when refreshing - thumbs down.
That is unfair Marcus. The video shows filtering out the unnecessary tables to prevent that issue. No data is mixed up. I demo refreshing it in the video.