hi.. if i like to create date on every new row the is created in the table. im using NOW(). how can i prevent it from updating every row? i just want it to run the NOW() once.
I have made a Table roughly the same as yours, why am I getting why am I getting this =Table1[[#This Row],[Sales]] and not =[@Sales]? In fact, I manually typed in =[@Sales]-[@COGS] it is giving me an error? I am using Excel 2007
The best Excel Table presentation on YT and i've watched all there is. Thanks !
Exactly "Excel Tables - Formulas, Basic to Advanced: what I was looking for usage of formulas using table notation
Very interesting Topic. Tks a lot
Thanks a lot, you saved good amount of effort
Great to hear!
Where can I find the files used in this video to practice?
Have you attached those in some other video?
All your videos are good. Can you teach us how we can make expandable table in google sheets like we have in excel??
Unfortunately, there is no such thing in sheets. Just regular ranges.
Great videos. Time to start using XLOOKUP function?
not a big fan of xlookup so far.
hi.. if i like to create date on every new row the is created in the table. im using NOW(). how can i prevent it from updating every row? i just want it to run the NOW() once.
11/14/2023 ~7:46
Very interesting. Nice to know. But in my opinion this is much easier in ms access.
I have made a Table roughly the same as yours, why am I getting why am I getting this =Table1[[#This Row],[Sales]] and not =[@Sales]? In fact, I manually typed in =[@Sales]-[@COGS] it is giving me an error? I am using Excel 2007
Would you mind showing how to make login form? I have watched userform on this channel, but it didn't show how if we enter login form.
Thanks
Does this work with pivot tables?
Yes.
Thank you sm
👍
Sir I have shared folder to other person & upload screenshot image do the work & how to lock & stop he is update image on next day with manage version
How can we convert hundred of small tables sitting in one sheet in an easy way instead of converting each table individually.
You would need to write a macro.
Hello everyone. Can anyone please help me to add a formula into my Excel table header?