Really good teaching. The flow from one example into the next was really well structured.
@Computergaga
3 жыл бұрын
Thank you, buddy.
@islamdp9107
2 жыл бұрын
Thank you very much. I was looking for this tutorial for months.
@Computergaga
2 жыл бұрын
Happy to help. Thank you.
@jasonjackson4555
2 жыл бұрын
Thanks for the tip. I’m beginning to use tables more often at work and this is exactly what I needed to know. I’m very disappointed in Microsoft for making such a common task so difficult to do in tables. I have years of muscle memory of just hitting F4 a few times to lock in a reference. Now I actually have to retype the column name and add a series of brackets and colons! Hopefully they improve this someday.
@Computergaga
2 жыл бұрын
You're welcome, Jason. Yes, hopefully they do. I completely agree.
@tanweerabbasabbas649
Жыл бұрын
Agreeee
@CarlosSantos-mz1kj
3 жыл бұрын
Great! Finally (after months searching) I know how to do that! Thank you very much! I really win my day...
@Computergaga
3 жыл бұрын
Glad I could help, Carlos.
@capricenutt5427
Жыл бұрын
First video that was actually able to help me with this issue. Thank you!!
@Computergaga
Жыл бұрын
You're welcome!
@wmfield152
3 жыл бұрын
This is a helpful demonstration, one that I can put to use right away--and avoid a lot of T&E to finally get right. Thanks as always, Alan!
@Computergaga
3 жыл бұрын
My pleasure
@IvanCortinas_ES
3 жыл бұрын
Thank you for the tutorial. Our beloved structured references!!!
@Computergaga
3 жыл бұрын
I absolutely love them 😊
@nomondenozulu5385
3 жыл бұрын
I've been looking for this...thanks a lot.
@Computergaga
3 жыл бұрын
You're welcome. Happy to help.
@THUNDERxSCREAM
Жыл бұрын
thanks, it was exactly what i wanted to know and more, keep up the good work
@Computergaga
Жыл бұрын
Thanks, will do!
@CeliaAlvesSolveExcel
3 жыл бұрын
Brilliant! Thank you for explaining this with do much detail.
@Computergaga
3 жыл бұрын
Thanks, Celia.
@darrylmorgan
3 жыл бұрын
Really Great Helpful Tips...Thank You Alan :)
@Computergaga
3 жыл бұрын
Thank you, Darryl.
@tanweerabbasabbas649
Жыл бұрын
Great video. There are not much on this subject and i was looking for exactly the same!!.👍👍😘😘
@Computergaga
Жыл бұрын
Glad you liked it!! Thank you 👍
@tanweerabbasabbas649
Жыл бұрын
What if we need to fix rows too in the same table scenario?. Plz make a short video on that🙏❤️
@patrickschardt7724
3 жыл бұрын
I don’t use absolute table references often so it’s always great to have a reminder
@Computergaga
3 жыл бұрын
👍
@LotfyKozman
3 жыл бұрын
Very useful, it is very interesting and new issue. Thanks a lot.
@Computergaga
3 жыл бұрын
Thank you, Lotfy.
@markhuang368
Жыл бұрын
Thank you so much.
@Computergaga
Жыл бұрын
You're welcome, Mark. Thank you.
@wayneedmondson1065
3 жыл бұрын
Hi Alan. Awesome tips! This is always a source of confusion. Thanks for the clear explanation. Interesting to note that if your references are all meant to be absolute, then instead of dragging the fill handle, you can use copy/paste or CTRL+R and you don't need to add the extra brackets and second column ID reference. But, if you have mixed absolute and relative needs, like in your example, then the copy/paste or CTRL+R method won't work (it will treat them all as absolute). Glad to know the correct syntax which will work no matter if you drag the fill handle, copy/paste or CTRL+R. Always clever tricks coming from Computergaga :)) Thanks and Thumbs up!!
@Computergaga
3 жыл бұрын
Thank you, Wayne. Yes, many people copy and paste the formula from the bar to prevent the changing column references. Ctrl + R is a nice method.
@markpodesta4605
3 жыл бұрын
Thank you. Maybe I should use tables a lot more.
@Computergaga
3 жыл бұрын
You're welcome, Mark. Yes, you definitely should 😊 I love them.
@teoxengineer
3 жыл бұрын
This is the secret property and I think nobody knows. Thank you very much 🤝
@Computergaga
3 жыл бұрын
Thank you, Emre 👍
@taibabs1222
2 жыл бұрын
Thanks
@Computergaga
2 жыл бұрын
You're welcome, Tai.
@ankurj9
3 жыл бұрын
I recently ran into this issue and thought how could I tackle it (making excel official table's cell an absolute reference) but couldn't find the answer and had to go back and convert my official excel table to range, make the needed cell as an absolute reference and then I proceeded with my work. I am glad that I found the answer now. Thanks Alan! BTW does this trick also works on cell ranges too if you want to make cell range an absolute reference?
@Computergaga
3 жыл бұрын
Happy to help, Ankur. No, you will need the classic absolute reference with the $ for cell ranges.
@ankurj9
3 жыл бұрын
@@Computergaga thank you!
@lucmorineau6741
3 жыл бұрын
Thanks for this helpful video. I'm looking for another use case where I would like to make a kind of indirection of the column header to address the targetted column in a formula. Do you have some suggestion to do it?
@Computergaga
3 жыл бұрын
Thanks, Luc. I am not sure exactly what you mean by the question, but I have videos on using INDIRECT with table columns headers. Also using XLOOKUP with a column header specified by a cell value. And also a recent video on sorting by a column selected from a drop-down - kzitem.info/news/bejne/qaCV05-PnZufaqA
@lucmorineau6741
3 жыл бұрын
@@Computergaga Thank you for your answer. The way to solve my issue is with indirect but I was making a mistake in the way I wrote the formula. Now it works fine.
@TropicScand
Жыл бұрын
Is this explained anywhere in the Help Pages for Excel or a Microsoft Support web page? I am looking for a key combination that does the [[column]:[column]] inset for me.
@Computergaga
Жыл бұрын
I'm sure it is somewhere but don't have it to hand. Not sure of a key combinations though it does help a little as you type. A neat trick is to select 2 column headers as Excel generates a range, that you can then edit. Saves half the typing.
@rrrrrr90923
3 жыл бұрын
hi, like i have said so many times before, you are very helpful. I do have one question though: how do you put a dot above the number when typing? Thanks :)
@Computergaga
3 жыл бұрын
Thanks, Ruth. Dot above the number?
@rrrrrr90923
3 жыл бұрын
Hi Sir, i am not aware of the mathematical term, but when a number goes on forever in a calculation, to save time, some of my teacher put a dot above the number to signal it is a repetitive number. I would rlly appreciate u showing us how to do that.
@Computergaga
3 жыл бұрын
Sorry, I don't know this.
@anoopjugurnauth7881
3 жыл бұрын
Hello sir, am anoop from mauritius. Am working on loto lottery,and i have come to a conclusion that we can win that. Sir. Am not good in excel. Please show me how to arrange the number already played so that i can arrange other number which is to be calculated from the formula you'd published. Please help me
@michalroesler
3 жыл бұрын
Yes.
@Computergaga
3 жыл бұрын
👍
@xiaojienan7891
2 жыл бұрын
How can u choose table column, not table column?
@Computergaga
2 жыл бұрын
Sorry, I don't understand the question. But you can either type the table followed by column in the formula, or you can click the table header to reference it.
@xiaojienan7891
2 жыл бұрын
@@Computergaga in your excel, when you select coulmn B, it is =AVERAGE(Grades[Maths]), when i select in a new excel that i created is =AVERAGE(B2:B7). mine does not show [ ], do you know why
@xiaojienan7891
2 жыл бұрын
@@Computergaga I have worked out because your data is table . Thx very much
Пікірлер: 61