Street Sort

Discuss ideas and suggestions around the Church website.
Post Reply
User avatar
WWS36
Member
Posts: 57
Joined: Mon May 21, 2007 11:04 am
Location: N. Ogden, UT

Street Sort

#1

Post by WWS36 »

Where can I get my ward sorted by Street address instead of Alphabetically?
User avatar
sbradshaw
Community Moderators
Posts: 5557
Joined: Mon Sep 26, 2011 9:42 pm
Location: Utah
Contact:

Re: Street Sort

#2

Post by sbradshaw »

There isn't currently a way to do that in Leader and Clerk Resources. You should send this as feedback using the "Do You Have Feedback" link at the bottom of the page. I've also sent feedback on this in the past. Some of the other columns are sortable, but not the address. Phone number would also be handy to sort, to organize by area code.
Samuel Bradshaw • If you desire to serve God, you are called to the work.
User avatar
WWS36
Member
Posts: 57
Joined: Mon May 21, 2007 11:04 am
Location: N. Ogden, UT

Re: Street Sort

#3

Post by WWS36 »

A good brother sent these EXCEL formulas to me and they work like a charm!!!
THanks, WWS
try these
=LEFT(A1,SEARCH(" ",A1)-1)
=MID(A1,SEARCH(" ",A1)+1,50)

or these
=LEFT(A2,SEARCH(" ",A2,SEARCH(" ",A2)+1)-1)
=MID(A2,SEARCH(" ",A2,SEARCH(" ",A2)+1)+1,50)
User avatar
sbradshaw
Community Moderators
Posts: 5557
Joined: Mon Sep 26, 2011 9:42 pm
Location: Utah
Contact:

Re: Street Sort

#4

Post by sbradshaw »

It's a lot of work to keep a separate spreadsheet, though – it'd be nice if Leader and Clerk Resources could sort.
Samuel Bradshaw • If you desire to serve God, you are called to the work.
User avatar
WWS36
Member
Posts: 57
Joined: Mon May 21, 2007 11:04 am
Location: N. Ogden, UT

Re: Street Sort

#5

Post by WWS36 »

Tell me about it. I'm doing the whole Stake!
Post Reply

Return to “Main Church Website”