Top Ad unit 728 × 90

Libreoffice

Libreoffice Writer

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: 5

No comments:

Contact Form

Name

Email *

Message *

Powered by Blogger.