Setting up an Advanced Filter
List Range:
First Last Address Zone City Postal Sales
John Brooks 44 Buffalo Rd SE Calgary T4T 6Y7 34,324
Beverley Chapman 445 Bowness Rd NW Calgary T2M 4G5 43,434
Paul Duriez 444 Jam St NE Calgary T2M 10X 43,543
Jane Fonda 456 Good Ave NE Red Deer T3G 8R3 45,000
Henry Ford 34 Long Blvd SE Red Deer T5D 4D7 45,434
Leslie Hignall 67 Horizon Rd NE Edmonton T9J 3B6 45,452
Pete Jones *click* NW Red Deer 45,980 <-- 3. Click in here
Tom McLaughlin 223 Scenic Way NE Calgary T2G 7U5 50,000
Dale McLaughlin 4565 Albert Rd NW Calgary T4G 6R5 54,343
Ralph Jones 234 Mancherst Rd SE Calgary T4G 7Y8 56,435
Sue Higgens 5346 Edmont Rd NW Calgary T73 8P9 56,465
First Last Address Zone City Postal Sales <--1. Copy/Paste
NW >45,000 <--2. Enter Criteria
Criteria Range:
4. Go to Menu Bar: Data/Filter/Advanced Filter
5. List Range should be highlighted
6. Highlight Criteria Range
7. Click OK
When done, go back to Menu Bar, Data/Filter/Show All to return to normal view.
Popular posts from this blog
Duas during last 10 Nights of Ramzan
Night of 21
ya mulija
fin nahare waya mulijan nahare fil laile wamukhrejal hayye minal maiyyete
wa mukyuzhebohrijal maiyyete minal haiyye ya raziqa maiyyasha beghare
hisabin ya allaho ya rahmano ya allaho ya raheemo ya allaho ya allaho
ya allaho lakal asmaaul husna wal amsalul ulya wal kibriyaaowal aalaao
asaloka an tusalli ala mohammadin wa aale mohammadin wa an tajalasmi
fee hazehil lailate fissoadaae waroohi maash shohadaae wa ehsani fee
illiyyina wa isaati maghfooratan wa an tahaba lee yaqeenan tubasahero
behee qalbi wa eemanan yuzhebus shaka anni wa turziani bema qasamta
lee wa aatina fid dunya hasanataoon waqina azabannaaril hareeqay warzuqni
feeha zikraka wa shukraka warraghbata ilaika wal inaabata wat tobata
wat taufiq...