Column,Columns,Row,Rows,Transpose Function in Excel
Column Function
=COLUMN(B2)
|
A |
B |
C |
1 |
Name |
Marks |
Position |
2 |
Raman |
48 |
2 |
3 |
Raj |
75 |
2 |
4 |
Karan |
85 |
2 |
5 |
4567 |
96 |
2 |
6 |
Deepak |
55 |
2 |
7 |
5263 |
96 |
2 |
8 |
Radha |
74 |
2 |
Columns Function
=COLUMNS(B1)
|
A |
B |
C |
1 |
Name |
Marks |
Position |
2 |
Raman |
85 |
2 |
3 |
Raj |
84 |
2 |
4 |
Karan |
96 |
2 |
5 |
Rahul |
62 |
2 |
6 |
Deepak |
74 |
2 |
7 |
Geeta |
52 |
2 |
8 |
Radha |
84 |
2 |
Row Function
=ROW(A2)
|
A |
B |
C |
1 |
Name |
Marks |
Position |
2 |
Raman |
48 |
2 |
3 |
Raj |
75 |
3 |
4 |
Karan |
85 |
4 |
5 |
Rahuk |
96 |
5 |
6 |
Deepak |
55 |
6 |
7 |
Kishan |
96 |
7 |
8 |
Radha |
74 |
8 |
Rows Function
=ROWS(A2:B8)
|
A |
B |
C |
1 |
Name |
Marks |
Position |
2 |
Raman |
48 |
6 |
3 |
Raj |
75 |
7 |
4 |
Karan |
85 |
7 |
5 |
Rahuk |
96 |
7 |
6 |
Deepak |
55 |
7 |
7 |
Kishan |
96 |
7 |
8 |
Radha |
74 |
7 |
Transpose Function
=TRANSPOSE(B2:B8)
Press Ctrl+Shift+Enter
|
A |
B |
1 |
Name |
Marks |
2 |
Raman |
48 |
3 |
Raj |
75 |
4 |
Karan |
85 |
5 |
Rahuk |
89 |
6 |
Deepak |
55 |
7 |
Kishan |
96 |
8 |
Radha |
74 |
Name |
Raman |
Raj |
Karan |
Rahuk |
Deepak |
Kishan |
Radha |
MARKS |
48 |
75 |
85 |
89 |
55 |
96 |
74 |
Column,Columns,Row,Rows,Transpose Function in Excel
Reviewed by ADcomputercampus
on
October 11, 2023
Rating:
No comments: