PDA

View Full Version : Sort By Value In Cell



parscon
05-17-2012, 07:00 AM
I open this Post again . : pray2:

if it is possible to sort a range by a specific value in a cell in a column within that range. The reason I'm asking is that I would like to sort by street name in an address line, ie:

500 Aldavar Rd, 32 564 Hughes Cresc, 36 Aldavar Rd, 14 263 Fairlane Ave

If these are samples in a cell, I would like to sort, and have the following "output":

36 Aldavar Rd, 500 Aldavar Rd, 14 263 Fairlane Ave, 32 564 Hughes Cresc

it is critical that "36 Aldavar" appears before "500 Aldavar" in the output and also 500 Aldavar Rd and after that 14 263 Fairlane Ave, 32 564 Hughes Cresc

Thank you .

kpark
05-17-2012, 07:30 AM
Are these values in a column with each cell containing a value?
or are all of those values in ONE cell?

Bob Phillips
05-17-2012, 07:52 AM
Are these values in a column with each cell containing a value?
or are all of those values in ONE cell?

You should check out the thread where the OP asked this before, http://www.vbaexpress.com/forum/showthread.php?t=42180. I gave up on it.

kpark
05-17-2012, 07:59 AM
.... I don't.... I don't.. I don't get it... -,.-;;

Bob Phillips
05-17-2012, 08:15 AM
Nor I.

parscon
05-17-2012, 08:22 AM
I add my description on http://www.vbaexpress.com/forum/showthread.php?t=42180 .

Please reply me . thank you very much .