8 replies
by dklippert
Have you looked at Knowlege Base article Q104185? It seems to cover the problem.
If it doesn't meet your needs, I'd be glad to look at a sample of your data.
by dklippert
Define your range using Insert>Name>Define.
If you define it as "=Offset($A$2,0,0,Counta($A$2:$A$200))" and then set one of your values as volitile (=Rand()*0+"value"). The range will define itself.
http://support.microsoft.com/support/kb/articles/Q183/4/46.ASP
by jamiek
by homer simpson instructor at large
I just tried this out a couple of days ago and an article I used as reference was this web page
http://msdn.microsoft.com/library/periodic/period98/SA98K6.HTM
It even has an example in the section you can download and check the formulaes out. It worked very well. It uses the offset option that you mentioned
hope it helps
by jamiek
by joshwilson
by jamiek
by jamiek
This discussion is closed to new replies.
Trending Windows Forum posts
Sort by Trending