thank you. you can always find functions that you've necver used in excel, even after over 20 years, he he. why not declaring the data as table, especially for the last formula. it makes it so much easier to read, especially with a large data set. instead of seeing cells addresses in the formula, you can actually read the headers.
It is definitely best practise to use tables, but I sometime avoid it when making example files especially when I use the same data in different sheets since each name needs to be unique.
Name formula is nice but it would be much more useful in real world situations if it could handle name suffixes like "Jr.","IV",etc. as well as name lists w/ and w/o middle names/ initials.
Brilliant video. Thanks ❤👍
GREAT
thank you. you can always find functions that you've necver used in excel, even after over 20 years, he he.
why not declaring the data as table, especially for the last formula. it makes it so much easier to read, especially with a large data set. instead of seeing cells addresses in the formula, you can actually read the headers.
It is definitely best practise to use tables, but I sometime avoid it when making example files especially when I use the same data in different sheets since each name needs to be unique.
Let me guess, you have never used BASE.
Name formula is nice but it would be much more useful in real world situations if it could handle name suffixes like "Jr.","IV",etc. as well as name lists w/ and w/o middle names/ initials.
Yes, but it's much more complicated 🤣
This is a situation where AI would be useful. You could use LABS.GENERATIVEAI function for this.
good and clean video format
Excellent Video
Excellent tutorial John, thank you for sharing it!!!
Thanks!