Hello and welcome to our new video
In this video we are going to learn about Array
What is Array?
Is Array a function?
Is Array a formula?
Array is nothing
What is Array?
Array is a function that gives its powers to a formula
Array does this
Now how to recognize whether Array is in a formula or not
We are going to see all those things in excel file
First of all, open the excel file
I will open the excel file from here
Ok I opened it from here
Here you will see some accessories are given
Their cost, unit and total
So what are the accessories I have
I have a mouse
I have a camera, drone
Pen drive, speaker, ram, display
And here its cost is written
Mouse will be 800
Camera will be 8900
Drone will be 90000
Pen drive will be 450
Speaker will be 2000
And here its units are given
How many units have been purchased
Mouse 3 units
Camera 2 units
Drone 1
Pen drive 5
Speaker 2
Now what to do
When I want to calculate total
How to calculate total
Now we will see without Array
First we will see without Array
How to calculate total
In normal case
I will put a sign
I will select this cell
Its name is written here
B2 is written here
What I did
I multiplied it
How much
I entered it
Now if I drag it
I know
After dragging
This formula will apply on all
So let's do the same
I will drag it from here
I dragged it down
I got to know
If camera is 8900
If I bought 2 units
How much it is
My drone is 17800
My drone is 90,000
I took 1 unit of it
My drone is 90,000
Apart from this
Pen drive is 450
I bought 5 units
My drone is 2250
This is done in normal case
Now let's calculate total
How to calculate total
I got to know 1,44,450 Total items
Total accessories
Till now
We have not used Array
This normal formula
B2 x C2
We have not used Array
How to use it
You have to understand one thing
When we use Array
We can use Array with single cell
Or we can use Array with multiple cell
First we will see
How to use Array with single cell
After that we will see
How to use Array with multiple cell
Here All my data
I will delete it
What you have to do
Select all the data
And Press Delete button
Everything will be deleted
Now we will see
How to use Array with single cell
I put equation 2
After that
I have to put sum formula
For sum formula
Double click here
Number 1
Number 2
In number 1
I have selected whole range
After that
I have to multiply
After that
I have to select whole range
After that
I have to enter here
Hash value
Why Have we done before
Multiply We used to do
Sum Total I will show you
Sum Total Equation Sum Select whole range
From B2 to B8
After that
I entered 1,14,150 We used to do like this
We used to do like this
Select whole range
Multiply Select second range
Will it work or not
Here Hash value
Now we have to
Give power to this formula
It will run
How will it run
What you have to do
On your keyboard
You will see 3 buttons
We have to press these 3 buttons
How will we do
I have to give power to this formula
I will press shift key
I will press control key
I will enter
I will get result
You can see
Total Total 1,14,450 We have to use this
Array in multiple cell
If I have to use
Array in multiple cell
How will we do
I will show you how to use
I will remove it
Now I have to select multiple cell
I have to select multiple cell
After that
I have to go to formula bar
After going to formula bar
I have to enter
Sir Then
Select
Then Multiply
And Enter
Does we have to enter
This is 2400
Now Drag it
Now it is nothing but the power of the array we could have
done this we could have done this 800 x 3 and then drag it
down it was calculating so what was the meaning of taking
range from b2 to b8 or c2 to c8 what was the meaning so
let's do it again it has no meaning it is just to tell you
what is the difference now we will give array power to the
same formula so let's delete it and select multiple cells
and go to formula bar
I wrote equals to now what I have to do select the whole
range and then multiply and select the whole range select
the whole range now what I have to do with my keyboard
press shift, control and enter press shift, control and
enter press shift, control and enter all the cells I had
were automatically calculated now I don't have to drag or
anything to total it what is simple to do select it and go
to autosum it will come 144450 now you will notice one
thing how will we know that array which is
formula how will we know that array is being used or not so
you will know from here you will see curly brackets these
curly brackets means that array has given its power because
it started then it ended so it means now the question we
know that in this formula array has given its power but if
I put these curly brackets in a normal formula then will it
get the power of array the answer is no it will not get
power so let's do let's remove or let's do it on the side
or let's do 800x3 or let's do
same thing which we have used here we will use the same
thing here
I will tell you in just a second now here let's do the same
thing equals to one second let's format it format printer
now we have to put equals to and we are doing the same
thing from b2 to b8 and then
I have multiplied after that I have selected it now I will
put curly brackets now I will do it by myself
I will press shift, control and enter to enable they don't
enable let's see what happens remember the power of array
if you want to give the power of array to any formula then
you have to enable it from keyboard and to enable what you
have to do press shift press ctrl and press enter without
these three things it will not work if you are thinking
that I do not press these three buttons with the help of
keyboard and here cleverly go to starting because we know
curly bracket it means we know in
my array is used
I put curly bracket here
I put it in starting and I put it at last so does it give
me the same result and enter so it does not give me
anything even it did not give me 800 x 3 it showed as it is
so one thing will be clear from here that to give array
power in any formula we have to enable and to enable we
have to press shift plus ctrl plus enter it will not work
very good now what we have to do one thing to understand if
I apply array in multiple cells then I can not change the
value it will not work like 17800 I put
sum
I will show you 2 4 one second
I have to do format painter
I selected it and here I entered format painter
I did it like this now I have to do all this
now what will happen
I wrote 4 here then I selected both and brought it down
normally I do auto sum and if I give array power in any
formula then how it works let's see
I did auto sum and it is 56 let's increase the size it is 56
one second auto sum it is 56 now what we have to understand
if I change any value from here like I wrote 100 and
entered then it is 146 total value is also changed and the
value I wanted to change is also in my hand but if you give
array power in any formula then it is not possible if I
want to change instead of 4000
I want to write formula
you can not change part of an array it should be clear that
we can not change array after applying formula when we saw
in normal case when we did auto sum we can change any value
and when we were able to change ok when we were able to
change then total value was also changed now how to remove
this it is very simple in this formula to remove this
select all and press delete button
I remove this also
I hope you understood that how we use array power in
formula if you still have any doubt then what you have to
do play video again and practice practice is very important
I will meet you in next video