Street Sort

Discuss ideas and suggestions around the LDS.org website.
User avatar
WWS36
Member
Posts: 52
Joined: Mon May 21, 2007 10:04 am
Location: N. Ogden, UT

Street Sort

Postby WWS36 » Tue Apr 12, 2016 2:35 am

Where can I get my ward sorted by Street address instead of Alphabetically?

User avatar
sbradshaw
Senior Member
Posts: 2484
Joined: Mon Sep 26, 2011 8:42 pm
Location: Provo, UT
Contact:

Re: Street Sort

Postby sbradshaw » Tue Apr 12, 2016 5:37 pm

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 • Interested in church apps and sites, creative recordkeeping, clerk support, YSA wards and stakes, LDS music, Vineyard at BYU, and online service.

User avatar
WWS36
Member
Posts: 52
Joined: Mon May 21, 2007 10:04 am
Location: N. Ogden, UT

Re: Street Sort

Postby WWS36 » Tue Apr 12, 2016 8:45 pm

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
Senior Member
Posts: 2484
Joined: Mon Sep 26, 2011 8:42 pm
Location: Provo, UT
Contact:

Re: Street Sort

Postby sbradshaw » Tue Apr 12, 2016 10:00 pm

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 • Interested in church apps and sites, creative recordkeeping, clerk support, YSA wards and stakes, LDS music, Vineyard at BYU, and online service.

User avatar
WWS36
Member
Posts: 52
Joined: Mon May 21, 2007 10:04 am
Location: N. Ogden, UT

Re: Street Sort

Postby WWS36 » Wed Apr 13, 2016 2:32 am

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


Return to “LDS.org Website”

Who is online

Users browsing this forum: No registered users and 1 guest