Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old 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
Default 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   Report Post  
Old 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
Default 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   Report Post  
Old 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
Default 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   Report Post  
Old 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
Default 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




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
absolute cell references Rusty Excel Discussion (Misc queries) 1 September 11th 08 05:16 PM
Cell References absolute? BobC Excel Discussion (Misc queries) 3 July 21st 08 04:11 PM
convert relative cell references to absolute cell references via amacro? Dave F[_2_] Excel Discussion (Misc queries) 1 May 15th 08 04:43 PM
Cell Absolute $ References Keep Changing themselves MarcP Excel Discussion (Misc queries) 4 September 7th 07 03:54 PM
Absolute references in a cell Glennk Excel Discussion (Misc queries) 1 January 23rd 07 04:28 PM


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

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017