6 hours 3 minutes
this lesson is going to about be about creating drop down lists and how to validate to data in a cell.
And this function is very useful if you're creating some kind of template or a table in which you were, some other people have toe enter day town a regular basis. So let's look at one example.
For example, you're just monitoring the
the temperature maximum daily temperature in a certain period of time. So you have day of the week and maximum daily temperature. And let's add another column, which would be, for example,
ah week number
so it can be from 1 to 52 you know,
regularly because one year has 52 weeks
so we want
us to prevent
somebody entering here, for example, 53 or entering here just number four instead off Thursday or Wednesday or whatever.
So we're going to delete this for a moment
and let's do first about week number
and, uh, let's go to date a validation.
And so we have been You know, when you click on this, we get to dissolve box, and we have here
settings and, uh
this tells us that
it can be a whole number decimal list, date, time, text or custom.
And it can be
Ah, let's a whole number
and let's say minimum is one
and maximum is 52.
So this way
we have limited what can be entered in this cell
between one and 52. Inclusive thes two values
Now let's try to enter here something that is not possible. So, for example, zero. We got them error message, which says this value doesn't measure the data values the Dacian restriction defined for this self.
and we can enter something else here. But also what we can do
is we can customize this message
and ah ah so we can click of warning
and we can click their message.
Ah, week number
between one and
And let's talk. Okay, so if we try to enter here like zero
can be between one and 52 they're going to continue. No. Yes. Now cancel. We say cancel and that's it.
here we have, ah, slightly different situation because we have a day of the week. It can be Monday, too,
or someday to Saturday depending on how you
look at the which days, starting day of the week.
then it, uh
you have to create the list.
So I have created list here. We have Monday, Tuesday, Wednesday, Thursday, Friday, Saturday, Sunday.
So I'm going to go here in data validation like undated validation.
And, uh, I'm just going to beckon settings. And now I'm going to choose list here,
and I'm going to click on source
and it's going to be like this
and I'm just going to sit on.
so now you get the drop down list here
and you can enter on Lee items from this list
Now, in case of week
number, we could have done the same thing, but then this list would had
and the it wouldn't fit on a screen, So it makes no sense.
So if we click your and maybe
zoom in a little bit so you can see a bit better.
So let's say it was weak 48 it was Wednesday,
and now we have maximum daily temperature. Now, this can be a negative number of positive number, but what we cannot allow here is for text to be entered.
So let's go to date a validation again.
can save can be a decimal number
because it can be negative. It can be positive.
And let's say that daily temperature, maximum daily temperature off. I don't know, minus 50
maybe doesn't make sense. But let's say that minus 60 is the minimum
and the maximum is maybe 60. So you cannot enter the daily temperatures. I don't know, 100 degrees. I'm talking about Celsius because it's ah,
it's not happening.
So let's take OK and hear if somebody wants to enter 75
well again, get the message off course, we can customize it, but it really doesn't matter for this
example. So you get this and of course, you can copy these cell before you entered anything and you can create
Ah, full table for the M in Ukraine, created for for quite a lot of number of cells and the formatting, the validation will copy with cells. So you can, uh, you can create your template or table in such a way that
people simply don't enter the wrong data.