Your Videos are the best for learning -You have a clear voice not too fast not too slow. You get straight to the point. I watched a lot of videos and I noticed that people tend to talk too much about nothing and not enough time spent on the tasks itself that they are trying to teach. Thank you for the lessons much appreciate your time and energy I am fast becoming a excel wiz thanks to you ! Cheers !
I have used this trick in the past to make my data change per what tab it is pulling the vlookup information from but needed a refresher on how to do it. Love the short, simple and precise explanation and I LOVE the table trick.
Hi! I need the help in excel. I have the data in excel. Column A and Column B. A1 = 1.5, a2=2, a3=2, a4=2.5, a5=3, a6=3. and comparing data in column b, b1=6203, b2=6203, c3=6204, c4=6205, c5=6205, c6=6206. now I need the validation list formula. If I type in cell L184=1.5 then in the list 6203 may appear as it is on a1 and on b1. if cell L184=2 then in the list 6203 and 6204 seperately show as the reference data is on a2, a3 and on b2, b3. if cell L184=2.5 then in the validation list 6205 may show as it is related with cell a4 and b4. if cell L184=3 then in the validation list may show 6205 and 6206 seperately as it is related with cell a5, a6 and b5, b5. please give me the formula for validation list.
That is a useful trick that I have frequently used to produce dependent dropdown lists.
Your Videos are the best for learning -You have a clear voice not too fast not too slow. You get straight to the point. I watched a lot of videos and I noticed that people tend to talk too much about nothing and not enough time spent on the tasks itself that they are trying to teach. Thank you for the lessons much appreciate your time and energy I am fast becoming a excel wiz thanks to you ! Cheers !
I have used this trick in the past to make my data change per what tab it is pulling the vlookup information from but needed a refresher on how to do it. Love the short, simple and precise explanation and I LOVE the table trick.
Great 👍
Very helpful. Thank you so much.
You're very welcome!
This really helped, thanks!
Is there a way to apply the Data validation only when a new row is created? Thanks!
Thank you So much
May Allah bless you
Thank you too
Highly Appreciated
Glad to help.
fixed my problem, thank you
thanks great options
You're welcome!
Great! Thank you!
Very clever.
Thank you!
Hi! I need the help in excel. I have the data in excel. Column A and Column B. A1 = 1.5, a2=2, a3=2, a4=2.5, a5=3, a6=3. and comparing data in column b, b1=6203, b2=6203, c3=6204, c4=6205, c5=6205, c6=6206.
now I need the validation list formula. If I type in cell L184=1.5 then in the list 6203 may appear as it is on a1 and on b1. if cell L184=2 then in the list 6203 and 6204 seperately show as the reference data is on a2, a3 and on b2, b3. if cell L184=2.5 then in the validation list 6205 may show as it is related with cell a4 and b4. if cell L184=3 then in the validation list may show 6205 and 6206 seperately as it is related with cell a5, a6 and b5, b5. please give me the formula for validation list.
Great
Thank you!
perfect
ty