I have a table with approx 10k addresses. they all have the same header but i need to sort by house number for each section.
Is there a way to sort this without selecting each section and sorting that way.
I have attached a sample to show what i mean.
Thank you in advance
What we need is the source data, or a sample of it.
Which version of Excel are you using? Please add this to your user profile.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
One way, using a helper column:
=IFERROR(IF(C1="Street",1000*COUNTIF($C$1:C1,"Street"),1000*COUNTIF($C$1:C1,"Street")+B2),F1+500)
in C2, copied down.
Select all the data, and sort using the helper column...
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
If you have really large street numbers (e.g. 1000 Railway Cuttings...), this may need to be tweaked by adding a couple more zeros to the 1000s and the 500.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks