Thread
:
Dynamic range based on another column
View Single Post
#
3
May 11th, 2010, 06:49 PM posted to microsoft.public.excel.setup
Carrie_Loos via OfficeKB.com
external usenet poster
Posts: 58
Dynamic range based on another column
Thanks!
Roger Govier wrote:
Hi
InsertNameDefine
Name RngO
Refers to =$O$1:INDEX($O:$O,COUNTA($H:$H))
or
Name lrow
Refers to =COUNTA($H:$H)
Name RngO
Refers to $O$1:INDEX($O:$O,lrow)
For more information take a look at a tutorial I wrote at
http://www.contextures.com/xlNames03.html
--
Regards
Roger Govier
I have a worksheet with several columns that I intend to update daily from a
data dump. I am trying to set up a dynamic range based on a previous column
[quoted text clipped - 8 lines]
Can anyone assist?
--
Message posted via
http://www.officekb.com
Carrie_Loos via OfficeKB.com
View Public Profile
View message headers
Find all posts by Carrie_Loos via OfficeKB.com
Find all threads started by Carrie_Loos via OfficeKB.com