Thank you so much for your videos and Excel files :) Just finished watching all 3 levels and they are helping me prep for an interview and now thanks to you I feel so much more ready!
In the question around 8:25 you mentioned concatenate!I wanted to ask you waht is the difference between concat () and concatenante().Because to concatenante, I use concat() and it still gives me the same as answer.
Also, With the Concatenate function, you will need to enter the cell addresses one by one. In this case, CONCAT looks much more compact. All you need to do is just pick the range with the Excel strings to concatenate. At the same time, both CONCAT and CONCATENATE look the same when you need to join text using delimiters.
INDIRECT doesn't work for me, it gives either #ref! or #value! errors, it works on that supporting file from your description that is premade but not when i make new one, i have not idea why
Hi! So this was rattling my brain too. Turns out, in the same way that he names the whole data "Staff," you must also name the ranges of each staff's last name and month accordingly. Then the dropdown menus and the indirect function beneath will be able to work with each different selection :) He shows us the shortcut to name cells but here's a little more info. Good luck! www.excel-easy.com/examples/names-in-formulas.html
Unfortunately, the INDIRECT function doesn't work for me either... It keep on giving me #ref! error. I had another situation where my excel would not accept a comma into a formula, but ";" instead. However, on this indirect function I don't get why it doesn't work... I named the table, I named all ranges, I created drop downs and I write the formula exactly like you and it doesn't work still :(
Sorry Andra, I have no explanation to offer. Not accepting a comma in a formula would indicate that you might need to check the keyboard type in your Windows settings.
I believe that you are referring to the drop down lists and they are created using data validation under the data tab. Click on data validation which brings up a dialog box. Under allow select list and under source highlight employee names for the L8 cell repeating the process for months using the months for the L9 cell.
Thank you so much, your videos are so easy to understand and you are so clear and have such a calming teaching presence - you are a great tutor!
Thank you for your kind comment, Francine.
Thank you so much for your videos and Excel files :) Just finished watching all 3 levels and they are helping me prep for an interview and now thanks to you I feel so much more ready!
Lena you are very welcome. Good luck with your interview. Let me know how it goes !
pro trick : you can watch series at Kaldrostream. I've been using them for watching a lot of movies lately.
@Nikolai Johan Yea, been using Kaldrostream for years myself =)
Thank you for these videos, It helped me so much. I learned more today than I have in years.
Thank you Connie
In the question around 8:25 you mentioned concatenate!I wanted to ask you waht is the difference between concat () and concatenante().Because to concatenante, I use concat() and it still gives me the same as answer.
You can use either
Also, With the Concatenate function, you will need to enter the cell addresses one by one. In this case, CONCAT looks much more compact. All you need to do is just pick the range with the Excel strings to concatenate. At the same time, both CONCAT and CONCATENATE look the same when you need to join text using delimiters.
Whew! I tried to watch & follow along after a long, hard day at work. That's not gonna work. I'll watch this anew first thang in the morning.
I am sure you will find it useful, D
@@unitedcomputers ... Useful, indeed! This Test Prep, along with your other Test Prep videos will be viewed over and over! ♥♥♥
Good on you, D
@@unitedcomputers ... Good day (or night), Mate!
INDIRECT doesn't work for me, it gives either #ref! or #value! errors, it works on that supporting file from your description that is premade but not when i make new one, i have not idea why
Have you named the cells? Remember no spaces when naming. However you do need a space between the two indirect functions in the formula.
Hi! So this was rattling my brain too. Turns out, in the same way that he names the whole data "Staff," you must also name the ranges of each staff's last name and month accordingly. Then the dropdown menus and the indirect function beneath will be able to work with each different selection :) He shows us the shortcut to name cells but here's a little more info. Good luck! www.excel-easy.com/examples/names-in-formulas.html
how to create that drop down menu at 12:33
I typed the months in a column, used Data Validation to create the list, then hid the column
Unfortunately, the INDIRECT function doesn't work for me either... It keep on giving me #ref! error. I had another situation where my excel would not accept a comma into a formula, but ";" instead. However, on this indirect function I don't get why it doesn't work... I named the table, I named all ranges, I created drop downs and I write the formula exactly like you and it doesn't work still :(
Sorry Andra, I have no explanation to offer. Not accepting a comma in a formula would indicate that you might need to check the keyboard type in your Windows settings.
You might want to try with another keyboard..preferably USB keyboard
thank you for this!!!
Thank you Faiza
How do you create the drop down in L8 and L9? Thanks!
This is for the INDIRECT function portion of the video at 11:28.
Use the data tab...see ua-cam.com/video/qo675r-4WOw/v-deo.html
In the INDIRECT file, you only need to select one cell for each drop down. Let me know how you get on with it...and a Happy New Year..:-)
I believe that you are referring to the drop down lists and they are created using data validation under the data tab. Click on data validation which brings up a dialog box. Under allow select list and under source highlight employee names for the L8 cell repeating the process for months using the months for the L9 cell.
thanks a lot for sharing.
Thank you !
great, thanks
Thank you !
pls check your indirect function was wrong
Thank you for your comment. I have double-checked the formula and found it to be correct. Can you please advise where you feel there may be an error.