CODEWITHSUNDEEP
excelexcel-formula
Raheel Khan
Raheel Khan

Reputation: 14787

Get the row and column number from within a cell in Excel using only formulas without macros

Is there a way to get the row and column of any given cell by inserting a formula into that cell?

So cell A1 would say (1,1), C2 would read (3, 2), etc. This would be kind of a self reference in a way.

Upvotes: 4

Views: 33049

Answers (3)

user1170055
user1170055

Reputation: 212

=CONCATENATE("(";COLUMN(A1);",";ROW(A1);")")

=>(1,1)

Upvotes: 1

chris neilsen
chris neilsen

Reputation: 53125

To self reference a cell, use

=CONCATENATE("(",COLUMN(), ", ",ROW(),")")

Upvotes: 16

ApplePie
ApplePie

Reputation: 8942

=CONCATENATE("(",COLUMN(A1), ", ",ROW(A1),")")

Edit: Removed unnecessary function call.

Upvotes: 4

Related Questions