Prev: How do you paste a list of bulleted text from a word doc. into exc
Next: I have 138 numbers, how do i get 15 random numbers from my data?
From: iamjbunni on 16 Mar 2010 20:14 I need to create a formula that automatically moves to the next cell containing data. I update reports weekly and want a summary formula to include the "new" data in the cell below. Any suggestions?
From: FSt1 on 16 Mar 2010 21:48
hi what kind of data? numeric? text? you would probably need a dynamic named range to sum. see this site. http://www.ozgrid.com/Excel/DynamicRanges.htm it explains the process. regards FSt1 "iamjbunni" wrote: > I need to create a formula that automatically moves to the next cell > containing data. I update reports weekly and want a summary formula to > include the "new" data in the cell below. Any suggestions? |