Hello All Excel Spreadsheet Formula Users,
Just to keep Incisor's Excel thread running.
Is there a What-If analysis, or some similar function, that can isolate the last four numbers of a column that should have featured in a spreadsheet as a separate column that identifies a post code. For example - find examples where the post code 4670 appears in a 70 page spreadsheet.
Here is a sample of what the author wrote Column "G" as:
23 Isaac Street, Deeragun, QLD 4818
6 Narabang Way, Belrose, NSW 2085
60 Margaret Street, Level 24, Sydney, NSW 2000
47 Bourbong Street, Bundaberg, QLD 4670
55 Fulham Road, Pimlico, QLD 4812
106 Cunningham Street, Dalby, QLD 4405
43 Gregory Street, Mackay, QLD 4740
78 Beischer Street, Bendigo, VIC 3550
Po Box 4546, Kirwan, QLD 4817
How could I write a formula that sorts the 4670 entries and their related data in the same row cells out for 4670?
The technique I have been using to date has been highlight column G and perform a Find function to identify each occurrence of 4670. This is a laborious task that will not get any easier as the file is updated every now and then.
I tried a "Custom Sort and Filter" however, the mixture of numbers and letters in the cell prevented it. The author is also inconsistent with their use of commas so "Comma delineation" does not work either.
I would appreciate assistance - thank you.
Kind Regards
Lionel
