Hello, everybody, welcome to the third dashboard. In this video, we will be populating this table from the data table that is from the master sheet. Now the calculations that we are going to do are something that we have done in the previous dashboard. That is job type man minimum salary of the world. That is in US dollars. That is the entire data.
Currently we have the records for the entire world. So that's from the whole data. And then what we're planning to do is we'll be doing the same process that is minimum maximum, but for the country selected by the user. So currently, it says all because the data is taken from cell A two. So you see the formula that we have here is equals to the minimum of whatever so sorry, whatever data is in cell A two and has been repeated in the next sales for average and so on. This particular Data is been retrieved from the dashboard where the user will be selecting the country as if I select Asia.
So what happens is from the given data, that is the data that becomes Asia. So, and now the minimum will be carried forward based on Asia, that is minimum salary of Asia and US dollars. And that's how the calculation will be done. Now, to do so, we will be using some array functions, some for average and some for formulas. So, let's get started. The first thing you have to do is name the data so we can use offset over here to make the data dynamic.
But to make it easier, we'll be just selecting the data to the right by using to select the data. First we'll keep the cursor on D one, then pressing Control Shift Down Arrow and right arrow, in turn will select the data bring this screen to the top will use Ctrl backspace and it will jump to the active cell. The view will be moved to the active cell Now once we are on the top of the formula tab, we'll be selecting create from selection. And the shortcut for that is Ctrl f3. So what that does is if I just keep it as left, turned off and keep the top as it is, whatever the heading is, will be given as the name range for the data below. Let's give it a try.
Once I click OK, nothing will happen on the screen. But if we select the data like say from D two onwards to the bottom, you can see the name box to the left we see heading, we see the heading has been taken as the name that job type. So it makes it easy to do the calculations. Let's do one of the calculations. So currently, I'll go with the simple one that is average if First we'll do the average calculation. So we'll be using the average if then versus the range that is a job, the job type.
The criteria is a criteria that we're looking for. Currently, it's finance, where a will be constant. So I'm using f4 to make the cell reference constant last but not least is salary in US dollars. And once done I'll close the bracket enter and there it is. So I got the average salary for the entire world for finance. In the next video, we will see how to get the minimum and maximum based on the conditions until then keep practicing keep learning take care