(Msg. 1) Posted: Tue Oct 27, 2009 1:06 pm
Post subject: sorting text with numbers Archived from groups: microsoft>public>excel>worksheet>functions (more info?)
I have been reading for the better part of two hours trying all of your
suggestions. I am still unable to get the following data to sort. I have
formatted the cells. The data is similar to this:
1
2
5
8
10
13
3a
3b
4a
6a
7a
7b
9a
11a
12a
12b
With data going on up into the hundreds.
trying all the formulas that were out there did not bring me even close. I
am using 2007.
(Msg. 2) Posted: Tue Oct 27, 2009 1:19 pm
Post subject: RE: sorting text with numbers [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Hi,
You need a helper column. Assuming your data in a1 down put this in B1 and
fill down. Now select both columns and sort on column B which can then be
hidden
> I have been reading for the better part of two hours trying all of your
> suggestions. I am still unable to get the following data to sort. I have
> formatted the cells. The data is similar to this:
> 1
> 2
> 5
> 8
> 10
> 13
> 3a
> 3b
> 4a
> 6a
> 7a
> 7b
> 9a
> 11a
> 12a
> 12b
>
> With data going on up into the hundreds.
> trying all the formulas that were out there did not bring me even close. I
> am using 2007.
>
> Thank you for your help...
(Msg. 3) Posted: Tue Oct 27, 2009 1:28 pm
Post subject: RE: sorting text with numbers [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Assuming the data you presented was in the order you wanted, and the letters
that are tagged are never more than 1 character, you could create 2 helper
columns.
Then go to Data, sort. Sort by Helper 1, then Helper 2.
--
Best Regards,
Luke M
*Remember to click "yes" if this post helped you!*
"wavers3" wrote:
> I have been reading for the better part of two hours trying all of your
> suggestions. I am still unable to get the following data to sort. I have
> formatted the cells. The data is similar to this:
> 1
> 2
> 5
> 8
> 10
> 13
> 3a
> 3b
> 4a
> 6a
> 7a
> 7b
> 9a
> 11a
> 12a
> 12b
>
> With data going on up into the hundreds.
> trying all the formulas that were out there did not bring me even close. I
> am using 2007.
>
> Thank you for your help...
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Profile
Private Messages
Log in
Office