Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 139
Default How to sort cells with cell reference to get the same numbers?

When i sort a range of cells with cell references the result is not the same
numbers as before! So can i lock the cells from changing or do something else
to get the correct values?
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
Formulas that reference cells that reference another cell Andrea Excel Discussion (Misc queries) 7 October 19th 06 08:14 AM
sort numbers high to low, copy to new cells with associated data. ucastores Excel Worksheet Functions 3 September 3rd 06 02:13 PM
Converting column & row numbers to a cell reference Graham Tritton Excel Worksheet Functions 2 November 15th 05 04:00 AM
Preserving cell reference after a sort Scott Emery New Users to Excel 1 March 20th 05 02:41 PM
How do I reference and sort a range of numbers in Excel 97? Old Northern Excel Worksheet Functions 3 December 14th 04 03:15 PM


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

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

About Us

"It's about Microsoft Excel"