Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
interesting excel sorting problem
There are two pieces of information in each entry. For clarity, I'll call one the "label" (A1, A2, etc.), and one the "value" (10, 9, etc.). The "label" only has meaning when compared to others in that series. e.g. "A1" should be ranked before...- adog
- Post #7
- Forum: Microsoft: Office
-
interesting excel sorting problem
OK, I understand the process you suggest. I agree that would be a wonderful way to solve the problem. But I can't figure out how to write the formula in the "C" column to sort the data in the way I want. You wrote earlier that you "can't follow the logic of my sort."...- adog
- Post #5
- Forum: Microsoft: Office
-
interesting excel sorting problem
JV- I'm not sure if I understand your advice. I pasted your command into my spreadsheet and played with it, and couldn't quite figure out what it was supposed to do. Let me take a step back and make sure I understand the idea that you propose: Are you suggesting that I write a new column that...- adog
- Post #3
- Forum: Microsoft: Office
-
interesting excel sorting problem
Hi: I have an interesting excel sorting problem. I have two lists of data (list "A" and list "B"). Each row in each list contains a "rank" and a "value". For example: List A: List B: rank value rank value A1 8 B1 10 A2 7 B2 6 A3 9 B3 4 A4 2 B4...- adog
- Thread
- Replies: 9
- Forum: Microsoft: Office
