Remember Me?

#1
January 19th 09, 07:32 PM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Jul 2006 Posts: 447
Absolute Cell References

I have to calculate the minimum and the maximum on the same range of cells
across multiple worksheets. I thought that I would just set up the cell to
calculate the minimum and then just copy and paste the formula in the cell
for the max. and then just change the =MIN to =MAX. When I do this, the
column references change. I'm guessing that the cell references have to be
absolute. Since I have all the minimums calculated, what is an easy way to
calculate the maximum so I don't have to choose each cell across the
worksheets again or change the column references?
Thanks, Karen

#2
January 19th 09, 08:10 PM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Feb 2007 Posts: 8,651
Absolute Cell References

If you copy from the formula bar, rather than copying the cell, then the
references won't change when you paste in another cell for the MAX.
--
David Biddulph

"Karen" wrote in message
...
I have to calculate the minimum and the maximum on the same range of cells
across multiple worksheets. I thought that I would just set up the cell to
calculate the minimum and then just copy and paste the formula in the cell
for the max. and then just change the =MIN to =MAX. When I do this, the
column references change. I'm guessing that the cell references have to be
absolute. Since I have all the minimums calculated, what is an easy way to
calculate the maximum so I don't have to choose each cell across the
worksheets again or change the column references?
Thanks, Karen

#3
January 19th 09, 08:49 PM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Jul 2006 Posts: 4,393
Absolute Cell References

If your worksheets all have the same structure (i.e the data is in the same
place and the formulas are to go in the same cells, then you can group the
worksheets and type the formula once.

Click the tab for the first worksheet; hold SHIFT and click the tab of the
last one (note how all the tabs between first and last now have the same
appearance); type formula in the cell and commit it (press ENTER, or use
green check mark in formula bar, etc); click a single worksheet tab to
ungroup.
Now all sheets have same formula.
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Karen" wrote in message
...
I have to calculate the minimum and the maximum on the same range of cells
across multiple worksheets. I thought that I would just set up the cell to
calculate the minimum and then just copy and paste the formula in the cell
for the max. and then just change the =MIN to =MAX. When I do this, the
column references change. I'm guessing that the cell references have to be
absolute. Since I have all the minimums calculated, what is an easy way to
calculate the maximum so I don't have to choose each cell across the
worksheets again or change the column references?
Thanks, Karen

#4
January 19th 09, 08:56 PM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Oct 2008 Posts: 15
Absolute Cell References

Karen:

Not sure how your spreadsheet is set up. Are there multiple formulas with
the MIN and MAX that you need to change to absolute reference? If it is set
up in rows like

=min(a4,a54)
=min(a55,a70)
etc....

Then the easiest thing to do would be to go to the edit menu, then go to
replace. In the "Find" dialogue box, enter a, and in the replace with box,
enter \$a\$

You can then copy the cells over 1 column and the cells will remain the
same.

"Karen" wrote in message
...
I have to calculate the minimum and the maximum on the same range of cells
across multiple worksheets. I thought that I would just set up the cell to
calculate the minimum and then just copy and paste the formula in the cell
for the max. and then just change the =MIN to =MAX. When I do this, the
column references change. I'm guessing that the cell references have to be
absolute. Since I have all the minimums calculated, what is an easy way to
calculate the maximum so I don't have to choose each cell across the
worksheets again or change the column references?
Thanks, Karen

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Rusty Excel Discussion (Misc queries) 1 September 11th 08 05:16 PM BobC Excel Discussion (Misc queries) 3 July 21st 08 04:11 PM Dave F[_2_] Excel Discussion (Misc queries) 1 May 15th 08 04:43 PM MarcP Excel Discussion (Misc queries) 4 September 7th 07 03:54 PM Glennk Excel Discussion (Misc queries) 1 January 23rd 07 04:28 PM

All times are GMT +1. The time now is 04:22 AM.