|
Excel sort formulas
I have an end user that is looking to have an excel spread sheet sort a
series of #'s with same parent # but with suffixes IE; 408237 408237A 408237B 408238 408238A 408238B or 408237 408237.1 408237.2 408238 408238.1 408238.2 ETC.... She's looking to have this done automatically if possible if not auto then a simple solution for additional end users who are novice at best. -- Michael Coble Rosendin Electric Inc Network Administrator Desktop Support |
Excel sort formulas
It is possible using helper columns.
If the first entry is in A1, then in B1 use =LEFT(A1:A6,6) and in C1 use =IF(LEN(A1)=6," ",RIGHT(A1:A6,1)) Now sort A1:C10000000 using Column B as first key and Column C as second key best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "Michael" wrote in message ... I have an end user that is looking to have an excel spread sheet sort a series of #'s with same parent # but with suffixes IE; 408237 408237A 408237B 408238 408238A 408238B or 408237 408237.1 408237.2 408238 408238.1 408238.2 ETC.... She's looking to have this done automatically if possible if not auto then a simple solution for additional end users who are novice at best. -- Michael Coble Rosendin Electric Inc Network Administrator Desktop Support |
| All times are GMT +1. The time now is 12:11 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com