LinkBack URL
About LinkBacks
This depends what row the formula is in but works in row 1
="C"&(ROW()-1)*5+2
Adjust +2 accordingly depending on what row you are pasting this to.
Use the INDIRECT formula on the result of this to get what you want
This depends what row the formula is in but works in row 1
="C"&(ROW()-1)*5+2
Adjust +2 accordingly depending on what row you are pasting this to.
Use the INDIRECT formula on the result of this to get what you want
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks