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 !
Very interesting Topic. Tks a lot
Thanks a lot, you saved good amount of effort
Great to hear!
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
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.
Where can I find the files used in this video to practice?
Have you attached those in some other video?
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.
Great videos. Time to start using XLOOKUP function?
not a big fan of xlookup so far.
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
Very interesting. Nice to know. But in my opinion this is much easier in ms access.
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
Hello everyone. Can anyone please help me to add a formula into my Excel table header?
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.
Does this work with pivot tables?
Yes.
11/14/2023 ~7:46
Don't know why simple SQL cannot be used. What MS has done is created something complex and overly verbose.