can you type the formulas for the countries it is hard to tell on the sheet above if there are spaces before or after the ( . I get it perfecting until the byrow formula is written. thanks
Hi if there are extra space then you can simply use trim function to avoid those error. I hope that will make clear . if not can give some more detail or even you can share the dummy sheet for me to review it for you.
Hi, I followed your instructions - thanks for the helpful video! Quick question, though. I managed to color code the first dropdown (Continents), but I'm stuck on color-coding the different items in the dependent dropdown based on the categories chosen in the first dropdown. for example: If I add a different color to the drop down background for each Country List dependent on Asia, it wipes out what I added as different colors to the drop down background for each Country List in Africa in the dependent dropdown list. Any tips on getting past this?
@@DataDashProthanks! Just finished watching it. Both videos are very helpful. ♥️ Question, with this video, we can insert row and formulas will be still the same. But for the multi tab video, the formula does not allow to insert row. Is there a way for this? Thanks again.
The GOAT of Excel and Google Sheets. Thank you so much!
can you type the formulas for the countries it is hard to tell on the sheet above if there are spaces before or after the ( . I get it perfecting until the byrow formula is written. thanks
Hi if there are extra space then you can simply use trim function to avoid those error. I hope that will make clear . if not can give some more detail or even you can share the dummy sheet for me to review it for you.
Thanks, man! It was really helpfull.
Ask me if any things else.
Sir
Anytime i change the continent, my data validation rule on country automatically disappears
Is there anything i may be getting wrong?
Hey did you develop the new sheet. Would possible to get a copy to review it?
@DataDashPro How may I contact you so I can send it sir
@DataDashPro Your second video worked for me
Thank you sir
Hi, I followed your instructions - thanks for the helpful video!
Quick question, though. I managed to color code the first dropdown (Continents), but I'm stuck on color-coding the different items in the dependent dropdown based on the categories chosen in the first dropdown. for example: If I add a different color to the drop down background for each Country List dependent on Asia, it wipes out what I added as different colors to the drop down background for each Country List in Africa in the dependent dropdown list. Any tips on getting past this?
can you share the sheet link. Just make a copy and share it and i will review it and explain to you
Hi! Can i use byrow across other tabs? Doing the formulas to a separate tab. Followed step by step and everyting is good until byrow formula.
For multiple tab please watch my second video
@@DataDashProthanks! Just finished watching it. Both videos are very helpful. ♥️
Question, with this video, we can insert row and formulas will be still the same. But for the multi tab video, the formula does not allow to insert row. Is there a way for this? Thanks again.
Hey, i watched your complete video & follow step by step, but don't know why when i type byrow formula it doesn't work. Please help
Did you do this in excel?
If so make sure you have excel 365 latest version but in google sheet it must work
Try copy my attached sheet
plz make more vedios like this😊
Sure
Is it possible with apps script? If so, please make a video on it sir.
Yes sure but that will be a little slower. Will make soon that as well