• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 174
  • Last Modified:

CURRENT ROW

I am trying to get the row number form CELL("address") in an excel formula
0
Svgmassive
Asked:
Svgmassive
1 Solution
 
Naresh PatelTraderCommented:
=CELL("ROW", A1) will return to row number of cell.
=CELL("address", A1) Will returns to $A$1

Thanks
0

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now