I have created a spreadsheet which includes addresses, post codes and other information.
I want to be able to type in a part of a post code and for all of the post codes that include that part of the post code to be displayed as well as the other information that's on the same row as that post code.
I am completely new to excel and so don't know how to use formulas or functions. At the moment I am just filtering to do this but its very time consuming.
e.g. From the segment of my spreadsheet below I want to be able to type in the first part of a post code BA1/ BA1 1 and for only post codes including that part of the post codes would then be displayed in a list.
List Description Day Site_PCode Site_Name Site_Addr1
280 KX05UWF Saturday BA1 5TJ HARE AND HOUNDS (LANSDOWN) LANSDOWN ROAD
280 KX05UWF Saturday BA1 2LS TOPLAND (ROYAL CRESCENT HOTEL) 15-16 ROYAL CRESCENT HOTEL
280 KX05UWF Saturday BA1 2LS TOPLAND (ROYAL CRESCENT HOTEL) 15-16 ROYAL CRESCENT HOTEL
280 KX05UWF Saturday BA1 1LP THE MAD HATTERS TEA PARTY 5 ORANGE GROVE
284 HX05KYB Tuesday BS31 1TN THE CO-OPERATIVE FOODS (PETROL STATION) PETROL STATION BATH ROAD
284 HX05KYB Tuesday BS31 3DJ DAY LEWIS PLC 374 BATH ROAD SALTFORD
284 HX05KYB Tuesday BA2 9ES FIRST BUS - WESTON ISLAND LOWER BRISTOL ROAD
284 HX05KYB Tuesday BA2 3ED UNITE GROUP WATERSIDE COURT LOWER BRISTOL ROAD
Type in BA1 1 and get the list as below.
280 KX05UWF Saturday BA1 1LP THE MAD HATTERS TEA PARTY 5 ORANGE GROVE
Type in BA2 and get the list as below.
284 HX05KYB Tuesday BA2 9ES FIRST BUS - WESTON ISLAND LOWER BRISTOL ROAD
284 HX05KYB Tuesday BA2 3ED UNITE GROUP WATERSIDE COURT LOWER BRISTOL ROAD
How do I ask excel to do this which is not as time consuming as filtering. I am mainly after a front page search bar to be able to search in this way within the spread sheet easily and quickly over multiple pages.
Many thanks
Neil
Bookmarks