A Sorting Dilemna
I need to do the following sort and have not figured out a way:
First sort by Column B ...ascending. Then compare Columns E, G, and I for highest value and sort Ascending. To be clear.....whatever is the lowest number in those three columns...it sorts first...regardless of what the other fields say. Your help is Appreciated!!!!! |
A Sorting Dilemna
If I understand correctly, maybe you could use a helper column. In an empty
column (let's say J2) enter: =MAX(E2,G2,I2) and copy down. Then sort your data using column B as the primary key and column J (helper column) as the secondary key. Then delete column J (if you like). "Terri" wrote: I need to do the following sort and have not figured out a way: First sort by Column B ...ascending. Then compare Columns E, G, and I for highest value and sort Ascending. To be clear.....whatever is the lowest number in those three columns...it sorts first...regardless of what the other fields say. Your help is Appreciated!!!!! |
All times are GMT +1. The time now is 11:38 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com