excel >> Data / Sort not working ????

by FISH » Fri, 23 Sep 2005 02:52:26 GMT

Hello all,

I'm basically a newbie to Excel and only create very basic spreadsheets with
basic function.

(I'm using Excel 2002)

I've creating a simple spreadsheet to keep track of finances. I'm having
problems with the "Data/Sort" function.

Not sure the best way to explain my satiation so I've pasted an example:


Customer Credits Debts Balance
Paul $200 $150 $50
Billy $200 $151 $50
John $200 $152 $48
Shawn $200 $152 $48
George $200 $155 $45
Aaron $200 $155 $45
Adam $200 $156 $44
Dave $200 $162 $38
Joe $200 $178 $22
AJ $200 $179 $21


I have another area of my spreadsheet that totals up the credits and debts.
So for example if the total credits for Paul are found in the cell B12, I've
entered =B12 into Paul's credit cell on this list. I've done this for each
credit and debt for each customer. The problem is when I try and sort the
data, the functions in some of these cells change and the data isn't sorted
properly. After I try and "data" / "sort" by the balance column it changes
(for example) Paul's credit cell to include the function =B17 (instead of
=B12 as I entered it originally)


Any idea why this "sort" function is acting strange??


Thanks...



excel >> Data / Sort not working ????

by Debra Dalgleish » Fri, 23 Sep 2005 06:21:31 GMT


Instead of a link to the cells, perhaps you could use a VLookup formula,
e.g.:
=VLOOKUP(I2,$A$2:$B$11,2,FALSE)

This might sort with better results.

There are instructions for VLookup in Excel's Help, and here:

http://www.contextures.com/xlFunctions02.html




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Similar Threads

1. Data Sort NOT working...

I've used this code for awhile, & it HAD worked.

But NOT now.

Range("DTop").Select
Selection.Sort Key1:=Range("AJ65"), Order1:=xlDescending, Header:=xlGuess _
, OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
DataOption1:=xlSortNormal

Is there another way to ensure a Sort??

TIA - Bob

2. Repeat function in Excel 2007 not working when sorting data - Excel

3. Excel 2003 Data Sort & Subtotaling not working properly

I am Subtotaling in Excel 2003 and the results are not even close anyone 
having any issues besides me. My test file is only 35 lines long and 6 
columns wide.

4. Data Sort in Excel not working - Excel Functions&Formulas

5. data sort is not including all columns in sort

I have a list with name, company, address, city.....etc.  When I click on 
data sort (i do check the box to include column headings) and do a sort by 
say address, it will sometimes exclude a column such as name from the sort.  
It does not always do this.  Is this a glitch?  Do I need to highlight the 
entire list before I sort?  

Also, sometimes if I just use the Ascending or Descending icon rather that 
going to data, sort it will only sort that column and not the rest of the 
data with it.  

6. Way to not sort when only a header row and one row of data to sort - Excel

7. How to AUTO SORT A-Z new data in a column (not menual sorting)

In a table I wish to insert data to a certian column and than to have the 
respected row sorted automatically accordingly.Meaning the whole table will 
be sorted 1 column but automatically as I insert the data to the column.
Thanks

8. New data will not sort with existing data from copied file - Excel Functions&Formulas