Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Programming / January 2008

Tip: Looking for answers? Try searching our database.

formula

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Newbie - 22 Jan 2008 15:32 GMT
Excel 2003

I have a spreadsheet that has groupings
           col a        b            c            d
row 1     2                                     sum(r2:r5)
row 2     1        =a2*a1
row 3    2           =a3*a1

If I want to copy the whole group -with the formula in Column B I can copy
the whole group (Row 1 to Row 3) and Insert Copied Cells and all is fine.

If I want to insert rows into the group then the column B formula changes to
a3*a2 (for eg)

If I change the formula in column b to a2*$a$1 I can insert rows within the
group ok but if I copy the whole group the new group is still looking at
cell A1

How can I overcome this problem - is there a way of perhaps naming the top
row of the group so that when the group is copied the formula always looks
at the top line of the group?

Thanks
Keith74 - 22 Jan 2008 16:41 GMT
Try inserting a dollar symbol "$" in front of the row number in your
formula.

hth

keith
Newbie - 22 Jan 2008 16:49 GMT
Thanks but that doesn't work when I start a new group becuase it will still
be looking at the original row1
> Try inserting a dollar symbol "$" in front of the row number in your
> formula.
>
> hth
>
> keith
Keith74 - 22 Jan 2008 17:14 GMT
Hi

Now i've worked out the problem, i'm afraid i dont know a way to do
what you're asking using formulas. Hopefully someone will correct me
but i dont think theres a way to preserve relative formula positions
in copies and inserts in that way
Newbie - 23 Jan 2008 10:26 GMT
Thanks anyway
> Hi
>
> Now i've worked out the problem, i'm afraid i dont know a way to do
> what you're asking using formulas. Hopefully someone will correct me
> but i dont think theres a way to preserve relative formula positions
> in copies and inserts in that way
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.