Hiya,
Hope everyone's well.
Is there any way I can get a cell's column number within a given range? Similar to =CELL("col"), but within a range (e.g. B2:G20).
Thanks
Hiya,
Hope everyone's well.
Is there any way I can get a cell's column number within a given range? Similar to =CELL("col"), but within a range (e.g. B2:G20).
Thanks
for the range (b2 : g20)
the column number should be
![]()
Please Login or Register to view this content.
I need your support to add reputations if my solution works.
row(), column() and Cell("col/column";reference) only return information of the upper left cell in the range.
What should your outcome be?
Looking for great solutions but hate waiting?
Seach this Forum through Google
www.Google.com (e.g. +multiple +IF site:excelforum.com/excel-general/ )
www.Google.com (e.g. +fill +combobox site:excelforum.com/excel-programming/ )
Ave,
Ricardo
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks