| Windows 7: Outlook Sorting Question |
26 Oct 2010
|
#1 | | Windows 7 Pro/32 Academic. Build 7600 Coral Springs, Florida |
Outlook Sorting Question I'm creating multiple columns in Excel 2007. For example; 10 rows in column "A", 10 rows in column "C" and 10 rows in column "E".
30 Items (cells) total.
What I'd like to do is sort them, A to Z, starting at 1A and ending at 10E.
Ic an't figure it out. I'm sure it's simple.
Thanks. | My System Specs |
| System Manufacturer/Model Number Custom Build OS Windows 7 Pro/32 Academic. Build 7600 CPU Intel 2.3 Duo core Motherboard EliteGroup G31T-M Memory 4 GB DDR Graphics Card Nvidia GeForce 9500 GT Sound Card Built in Monitor(s) Displays Viewsonic 15" 4:3 Screen Resolution 1280 x 1024 Keyboard Standard windows Mouse Logitech USB PSU Antec 450w Hard Drives WD Caviar Black 750 GB
WD 250 GB External Internet Speed Bellsouth DSL 6.0 |
26 Oct 2010
|
#2 | | Windows 7 Home Premium SP1, clean install, upgrade disc CT |
I should be able to help you with this, since I am proficient in excel.
The columns and rows are already numbered.
Under the home tab, and on the right sort and filter is what you need, for further sorting.
Give me more information, if this is not precisely, what you need. | My System Specs | | System Manufacturer/Model Number Dell XPS 420 OS Windows 7 Home Premium SP1, clean install, upgrade disc CPU Intel Core2 processsor Q8200(2.33Ghz 1333FSB) Quad Core Tech Motherboard Dell Memory 6 gb Graphics Card ATI Radeon 256MB HD3650 Sound Card Intergrated 7.1 Channel Audio Monitor(s) Displays Dell SP2009W 20" Keyboard Dell USB Keyboard Mouse Dell Premium Optical USB Cooling Fan Hard Drives 640 GB Serial ATA Hard drive Internet Speed DSL 2.85 |
27 Oct 2010
|
#3 | | Windows 7 Pro/32 Academic. Build 7600 Coral Springs, Florida |
Thanks, Rich. The Sort and Filter command is where I'm having issues. Seems I cannot sort more than one column at a time. With multiple columns selected, nothing sorts. I've tried "from column A" and then gone and selected "And then from column B" but it's a no go. I need the sorting to look like this; | My System Specs | | System Manufacturer/Model Number Custom Build OS Windows 7 Pro/32 Academic. Build 7600 CPU Intel 2.3 Duo core Motherboard EliteGroup G31T-M Memory 4 GB DDR Graphics Card Nvidia GeForce 9500 GT Sound Card Built in Monitor(s) Displays Viewsonic 15" 4:3 Screen Resolution 1280 x 1024 Keyboard Standard windows Mouse Logitech USB PSU Antec 450w Hard Drives WD Caviar Black 750 GB
WD 250 GB External Internet Speed Bellsouth DSL 6.0 |
27 Oct 2010
|
#4 | | Windows 7 Home Premium SP1, clean install, upgrade disc CT |
I think that you may not using the custom sort function. Take a look at this and see if it fits your needs Sort data by multiple columns in Excel 2007 | Excel Digest | My System Specs | | System Manufacturer/Model Number Dell XPS 420 OS Windows 7 Home Premium SP1, clean install, upgrade disc CPU Intel Core2 processsor Q8200(2.33Ghz 1333FSB) Quad Core Tech Motherboard Dell Memory 6 gb Graphics Card ATI Radeon 256MB HD3650 Sound Card Intergrated 7.1 Channel Audio Monitor(s) Displays Dell SP2009W 20" Keyboard Dell USB Keyboard Mouse Dell Premium Optical USB Cooling Fan Hard Drives 640 GB Serial ATA Hard drive Internet Speed DSL 2.85 |
28 Oct 2010
|
#5 | | Windows 7 Enterprise x64 North Somerset, UK |
Excel doesn't let you sort discontinuous blocks of data because it carries with it a significant risk of seriously messing up your data.
Are the columns between the columns you want to sort, empty? In your example, are columns B, D and F simply empty columns? If so, delete them, then sort the data as usual, then reinsert blank columns where you want them.
Hope this helps - though I may have misunderstood your question... | My System Specs | | System Manufacturer/Model Number Custom OS Windows 7 Enterprise x64 CPU Intel i7 920 Motherboard Asus P6T Deluxe v2 Memory 6 GB Graphics Card nVidia GTX260 + nVidia 3D Sound Card Onboard Monitor(s) Displays Samsung SyncMaster 2233RZ Screen Resolution 1680 x 1050 PSU 700W Hard Drives 1 x 64GB SSD primary
2 x 1 TB (mirrored) Other Info Edimax 802.11n Wireless PCI Card
Netgear DG834G router |
28 Oct 2010
|
#6 | | Windows 7 Home Premium SP1, clean install, upgrade disc CT |
Clunkfish is correct. But using custom sort, you are able to sort the data as shown in the example that I sent you. | My System Specs | | System Manufacturer/Model Number Dell XPS 420 OS Windows 7 Home Premium SP1, clean install, upgrade disc CPU Intel Core2 processsor Q8200(2.33Ghz 1333FSB) Quad Core Tech Motherboard Dell Memory 6 gb Graphics Card ATI Radeon 256MB HD3650 Sound Card Intergrated 7.1 Channel Audio Monitor(s) Displays Dell SP2009W 20" Keyboard Dell USB Keyboard Mouse Dell Premium Optical USB Cooling Fan Hard Drives 640 GB Serial ATA Hard drive Internet Speed DSL 2.85 |
28 Oct 2010
|
#7 | | Windows 7 Enterprise x64 North Somerset, UK |

Quote: Originally Posted by richc46 Clunkfish is correct. But using custom sort, you are able to sort the data as shown in the example that I sent you. The method given in Richc46's excellent link still won't allow sorting of discontinuous blocks of data - in other words, it would still sort columns B, D and F as shown in the OP's example. If I understand correctly, the goal is to sort columns A, C, E and G but leave B, D and F untouched. As far as I know, that isn't possible (and for good reasons).
If B, D and F are empty, they can be sorted without changing anything; if they contain data, won't the values need to remain associated with other data in the same row, and thus have to be sorted anyway? | My System Specs | | System Manufacturer/Model Number Custom OS Windows 7 Enterprise x64 CPU Intel i7 920 Motherboard Asus P6T Deluxe v2 Memory 6 GB Graphics Card nVidia GTX260 + nVidia 3D Sound Card Onboard Monitor(s) Displays Samsung SyncMaster 2233RZ Screen Resolution 1680 x 1050 PSU 700W Hard Drives 1 x 64GB SSD primary
2 x 1 TB (mirrored) Other Info Edimax 802.11n Wireless PCI Card
Netgear DG834G router |
28 Oct 2010
|
#8 | | Windows 7 Pro/32 Academic. Build 7600 Coral Springs, Florida |
Thanks, clunkfish, for the update. To answer your question, no, columns B, D, and F are not empty, they contain numerical values. I don't want the numerical values sorted, though, just the alpha values. | My System Specs | | System Manufacturer/Model Number Custom Build OS Windows 7 Pro/32 Academic. Build 7600 CPU Intel 2.3 Duo core Motherboard EliteGroup G31T-M Memory 4 GB DDR Graphics Card Nvidia GeForce 9500 GT Sound Card Built in Monitor(s) Displays Viewsonic 15" 4:3 Screen Resolution 1280 x 1024 Keyboard Standard windows Mouse Logitech USB PSU Antec 450w Hard Drives WD Caviar Black 750 GB
WD 250 GB External Internet Speed Bellsouth DSL 6.0 Outlook Sorting Question problems? All times are GMT -5. The time now is 01:31 AM. | |