0:00
hello and welcome to tutorial's point in
0:02
this video we are going to understand
0:04
the take function in Excel whether you
0:06
are a beginner or an advanced user I
0:09
will show you how to use take function
0:11
to extract rows columns and more from
0:13
your data with e also you can download
0:16
this practice sheet from the link in the
0:18
description below now open your Excel
0:20
sheet and let's get started so here I
0:23
have the sample data of ID name
0:26
Department salary joining date and
0:28
performance rating now let let say I
0:30
want to retrieve the first three rows so
0:33
I only want first three rows here so to
0:36
get those first three rows we'll use the
0:38
take function so this is the basic and
0:39
simple usage that we can start with the
0:41
take function so here I'm going to write
0:43
the formula equals take parenthesis and
0:48
then it asks for the array in this case
0:50
array is the data so I'll select all of
0:53
these Cs and then a comma and then it
0:56
asks for rows so we want the first three
0:58
rows so I'll simply write three and
1:01
close the parenthesis once I hit enter
1:03
as you can see we have the first three
1:05
rows so this is how we use the take
1:08
function now let's say instead of the
1:10
first three rows I want the last three
1:13
rows to do that I can simply modify my
1:16
formula and here we we I have written
1:19
first three rows instead of that I'm
1:21
going to write a -3 which means last
1:24
three rows if I hit enter as you can see
1:27
we have the last three rows
1:30
here now this was just a basic usage of
1:34
the take function now let's take some
1:36
more usage of it so I'll click here on
1:39
sheet two and in sheet two we have the
1:42
exact same data but now what I want here
1:46
is I want to retrieve some columns so
1:48
for example let's say I want to retrieve
1:51
first three rows we already did this how
1:53
we did it I uh I wrote equals take
1:57
parenthesis and then we select our
1:59
entire data and then comma then we want
2:01
the number of rows let's say I want the
2:03
first three rows and then I'll close the
2:05
parenthesis and hit enter and we have
2:08
first uh three rows but uh let's be more
2:11
specific let's say for these three rows
2:13
I don't want all of the columns I only
2:16
want the ID column name column
2:18
Department column and salary column so I
2:20
only want first four columns now in this
2:23
case I can also use the take function so
2:26
here I have written the number of rows
2:28
and then I'll write a comma and then it
2:30
asks for columns so I can say I only
2:33
want first four columns which is up to
2:35
salary right so I'll hit enter and as
2:38
you can see we have only first four
2:40
columns this is ID name uh department
2:43
and salary so this is another use case
2:46
of take a function now similarly let's
2:50
take another example let's say that I
2:53
want the last two columns of the last
2:56
four rows so firstly we need last four
2:58
rows I'm I'm going to to modify my
3:00
formula so here after selecting the data
3:03
I will write minus 4 and it will give me
3:06
the last four rows something like this
3:08
but we don't want all of the columns
3:11
here so uh let us say I only want the
3:14
salary joining date and performance
3:17
rating column so I only want the last
3:19
three columns for these four rows so I
3:22
modify my formula and here after the
3:24
minus 4 I'll write comma and for the
3:26
columns I will say minus and then how
3:30
many columns we want let's say I want
3:32
salary joining date and performance so
3:33
I'll write -3 which means I want the
3:36
last three columns only if I hit enter
3:40
as you can see we have the salary we
3:42
have the joining date and we have the
3:43
performance rating now don't worry these
3:45
joining dates have to be basically
3:47
formatted so if here I click on short
3:50
date it will give me the date so this is
3:54
how we use take function in Excel now
3:58
before ending the video Let's Take some
4:00
more advanced use cases so here I'll
4:02
click on sheet three and we have again
4:05
the exact same data now here is the
4:08
thing what I want is I want the first
4:11
employees so basically I want top three
4:13
employees so we have the performance
4:15
rating here and I want the first free
4:18
employees with a performance rating of a
4:20
all right so basically I'm looking for
4:22
this person then this person and then
4:24
this person not this one all right so I
4:27
want the first three employees with a
4:29
performance rating of a in that case we
4:32
will use a function called called as
4:35
filter so firstly I'll write filter and
4:38
then parenthesis and then it asks for
4:40
the array in our case it is the entire
4:42
data and then a comma then it asks for
4:46
include and for the include what we want
4:49
is basically we are looking for the
4:52
performance rating so here what I'll do
4:55
is as you can see we have this column
4:57
I'll select the entire performance
4:59
rating column something like this and I
5:01
will say if this column equals and then
5:05
a all right so if this column equals a
5:09
and then I'll close the parenthesis and
5:11
hit enter and as you can see we have the
5:14
four total employees with a performance
5:16
rating of a but I want to be more
5:19
specific now I only want first three
5:22
employees I don't want this fourth one
5:24
so here again we are going to use the
5:26
take function so here I'm going to wrap
5:28
this full bu a function inside take
5:30
function I'll write here take and then
5:33
open parenthesis and here I'll have a
5:35
comma and I will write three which means
5:38
first three rows only and then close the
5:41
parenthesis and hit enter and we have
5:43
the first three employees with a
5:46
performance rating of a now let's take
5:50
another last example let's say I want to
5:53
find those employees that have the least
5:57
salaries so basically I am looking for a
5:59
three employees that have the least
6:00
salaries so if we look inside uh this
6:04
table you may notice that the least
6:06
salary here is George and after that the
6:10
least salaried person here is Alice and
6:13
then the least salaried person after
6:16
Alice is uh Fiona all right so we have
6:20
George we have Alice we have Fiona so
6:21
basically we want the uh we we want to
6:24
retrieve the bottom three salaries so
6:26
we'll use again the take function here
6:28
but to get the data first we'll use some
6:30
other function so here I'll write that
6:32
function I'll say sort and then
6:34
parenthesis now inside we we have to
6:36
write array in our case it is going to
6:38
be the entire data and then a uh comma
6:42
and after that it asks for sort index so
6:46
basically on which column we want to
6:48
sort this data now as you can see we
6:50
want to sort it on the basis of salary
6:52
so here as you can see salary is fourth
6:54
column see ID is one name is two
6:56
department is three and salary is fourth
6:59
column so here in the formula I will
7:01
write four and then a comma and then it
7:04
asks for ascending and descending we
7:06
want the ascending order so one and then
7:08
I'll close the parenthesis and hit enter
7:11
and as you can see it basically uh it
7:14
basically sorts the data in ascending
7:16
order according to the salaries all
7:19
right but what is our task our task is
7:21
to have only the uh three least salaried
7:25
employees which are actually George
7:27
Alice and John so we only want these
7:29
three rows so here we're going to use
7:31
the take function so we'll wrap this
7:33
sort function inside the take function
7:35
I'll write take parenthesis and then
7:38
here I'm going to write a comma and then
7:40
I only want three so I'll close the
7:43
parenthesis and hit enter and as you can
7:46
see we have retrieved the bottom three
7:50
salid employees which are George and
7:52
then Alice and then John so this was
7:55
another use case of take function in
7:58
Excel so that will be enough for this
8:00
video I hope you found this video on the
8:03
take function helpful don't forget to
8:05
download the Excel practice file from
8:07
the link in the description and try it
8:09
out yourself if you like this video give
8:11
it a thumbs up share it with your
8:13
friends and hit that subscribe button
8:15
for more Excel tips and tricks
