Комментарии:
Really Helpful it became useful to me for Analysing my Personal Budget more convinietly.👍👍😀
ОтветитьMadam, How to remove the blank from the slicer.. Kindly advise me
ОтветитьI found in 365 with a drop down list on 1 sheet, to use it on another in a drop down I had to make the source: =DDList!C$3# otherwise the source changed the reference to C3# to C4#, etc. Do you confirm that happens to you as well? I didn't think it should change.
ОтветитьThanks, Mynda. I really thought that you had solved my problem when you spoke about named ranges on another sheet. Alas, it doesn't seem to have helped. Nor has moving the list back to the current sheet.
Problem: I want to use searching inside drop-down lists. I had it working in Excel 2019. Then it stopped working (probably because I moved the list to another sheet, or I hid it) So I upgraded to Office 365 (not MS Insider). It still doesn't work. Suggestions?
Thank you. I knew I could do this and couldn't work out why I was failing yesterday (I have the source data in different tab).
ОтветитьGreat video. You use the list in a column. Is it possible to use the same list in different cells that they are not in the same column?
ОтветитьSo when you use an alternate worksheet and a table, then you use a defined name, when you are filling in the list for data validation, type "=" and then use the F3 key to see the list of Named ranges.
ОтветитьGreat Video’s! I have a question about 06.45 in this video. In this case I still need to make a list on a separate sheet and then use this as the reference in de date validation section. Would it also be possible to directly write in the date validation section>List>Source the formula, like: =unique(data[Geography]) I have tried different options but I couldn’t get it to work.
ОтветитьThanks. Can we updates the information of the data validation drop list ? How?
ОтветитьI really don't understand why such a usefull function would be used online but then excluded in the desktop version..
ОтветитьI encountered error saying "The Source currently evaluates to an error." How do I solve this? Appreciate your help. Thank you in advance.
ОтветитьDrop list on google is better. I hope excel can update 😌
ОтветитьThank you for the video, but it didn’t work on dates data, i don’t know why, so if anyone knows please inform me.
ОтветитьU rock girl.. !!!!!
ОтветитьWhen i update the table, the drop down list is not getting updated , even though the source list is formatted as table
ОтветитьThanks for your great validation updates 🙏❤️👍😍
ОтветитьTHis was exactly what I was looking for, thank you.
ОтветитьMUCH better than other videos out there.
ОтветитьThanks
ОтветитьWish I found this video sooner! Very clear & concise. Thank you so much. Liked & subscribed
ОтветитьI thought I was tripping when it cell reference changed when you had it as an absolute reference when you first selected the data. I use to always use offset to make it dynamic. This is much easier. Always a fan of your work!
ОтветитьDo you have a video on how to connect multiple drop down list? Thank you
ОтветитьMynda, thanks! if I want show two column showing in the dropdown but only return information of one value, e.g. have Product ID /Name showing in the drop down, once select only return the Product ID. is that possible? thanks
ОтветитьAnother thanks from a very satisfied follower! Is there a way to bypass Excel on using two columns to create a drop down list? And thanks!
ОтветитьWhat were the chances of that??? I was using a spreadsheet (I do everyday!) but the data in the list wasn't available in the drop down so I had to do a bit of research (google) to sort it out. However, now I can learn more about it and properly :D
ОтветитьLots of thanks for you ! but how to get rid of blanks while ticking on the "ignore blank" Data validation box?
ОтветитьI really like your lessons but being a bit green on excel, i find myself floating most of the times.
How can i get introductory lessons?
Thank you so much!
Ответитьvery helpful video Thank you
ОтветитьMynda, thanks for the beautiful video.
Although I am registered to Beta channel and I have an Office 365 license, unfortunately I cannot use many features used after a while.
Excel software developers need to solve this quickly. We use many formulas developed for test purposes in our data analyzes, but then the formulas in our work have not started to work because the access to these formulas was restricted!
I have a question for data verification:
Can we create more than one data verification list in a single cell?
Thank you a lot, that was really valuable, I like your videos, they are straightforward and detailed
ОтветитьLearn a new thing again.. Thanks for uploads..
Ответитьlot of thanks for you ! really this is what I was missing to understand especially using the height and width in offset formula . please keep going posting such valuable videos .
ОтветитьHello blogger, thank you for your sharing, I watched a few videos you made, which are very lively and interesting, how can I contact you?
ОтветитьAwesome..
Simple and easy to follow..
Thank you so much..
Do You know Mynda !!!
I Love You !
Aaah, Off Course ! You know it !
Kanwaljit
in the other hand, i adore your accent. i always love british accent
ОтветитьSo much easier creating good dynamic validation now, no need for offset formulas. You can also wrap your unique formula in the sort function as well.
ОтветитьVery clear.... Can you suggest me formula for date series when date of Saturday & Sunday are automatically removed when draging that formula from cell A2 to A30 ?
ОтветитьFirst, thank you for all the informative info, and professional videos.
I want to mark that Data Validation list will not be updated as shown in the video if the list is on another sheet (maybe a bug?).
How do you make the font in the drop-down list larger ?
ОтветитьShort and Informative as usual
ОтветитьThanks video explaining various options for drop down lists nicely.
ОтветитьThanks for the information. Usually, when I use a table on another sheet I would use the indirect command for data validation. Example:
=INDIRECT("ExtCategoryList[Categories]")
The defined name seems a lot easier.
Definitely timely...
I would welcome something describing the following:
Dropdown List of Names - BUT - when selecting the Name - it actually returns a numeric value associated with the Name.
Ex: I have a TBL with 2 columns - Region No & Region;
I want the User to choose the Region - BUT - I need the Region No to be returned...
Region No = 1 and Region = EU
Dropdown shows = EU but when selected - the value for Region No = 1 is placed in the cell.
I can accomplish with a multitude of steps - but I'm thinking some variation of Data Validation would work
As always, this was very informative.
I wonder why the data validation table update was rolled back to no longer auto update as new items are added.
The spilled ranges do auto update
That part of using unique and sort is amazing for those with office 2021or Microsoft 365. I always get something new from your tutorials..big thanks
Ответить