LinkBack URL
About LinkBacks
Assuming your header row is in Row 1, use in A2
=IF(B2,ROW(A2)-1,"")
Format the cell & copy down
Assuming your header row is in Row 1, use in A2
=IF(B2,ROW(A2)-1,"")
Format the cell & copy down
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks