I have a list of 3-digit numbers in column A and would like to order them in another column say B as follows.
e.g
122 nXX
212 XnX
221 XXn
Where n is the non-double digit.
Last edited by Sweetypie; 04-02-2010 at 02:24 PM.
You may want to provide a few more examples than this, preferably in a spreadsheet. Show the list before, and the list after, and explain why the results are sorted the way they are.
i am just trying to order/format numbers according to the following rule:
i have a list of numbers all in 3_digits but 2 digits are the same. i want separate column that identifies each number as nXX, XnX, or XXn.
where n and X are numbers fro the set 0,1,2,3,4,5,6,7,8,9
Last edited by Sweetypie; 04-02-2010 at 01:45 PM.
As Paul hinted: upload a sample spreadsheet that meets this criteria:
1. It exactly duplicates the structure of your real workbook AND,
2. It contain representative but non-sensitive dummy data, AND
3. It manually illustrates the desired outcome using a several clear examples
To upload a sample workbook:
1. Edit your previous post, click Go Advanced
2. Scroll down the page until you see the button "Manage Attachments"
Palmetto
Do you know . . . ?
You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.
Didn't really look at the spreadsheet, but from your example if A1 has the number, B1 can be =IF(Left(A1)=Right(A1),"XnX",IF(Left(A1)=Mid(A1,2,1),"XXn","nXX"))
Darkyam, thanks. you are awesome. Once again you came thru.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks