Validating two different cells in a specific row

niyamath

New Member
Joined
Jul 20, 2017
Messages
4
I am currently parsing the dataset we have, Need to validate cleansed dataset for error.

I have the complete address in 1st column and have parsed the data in adjacent columns, Now I need to validate that the information is parsed correctly.
For example, the postcode in Cell G1 is part of the address in cell A1.
Book1
ABCDEFGH
1AddressAddress 1Address 2Address 3CityStatePost CodeCountry
2Tour B, Cœur Défense, 110 Espl. du Général de Gaulle, 92400 CourbevoieTour BCœur Défense110 Espl. du Général de GaulleCourbevoie92400France
3Unit 1, Chancellor Court, 50 Occam Rd, Guildford GU2 7AB, United KingdomUnit 1Chancellor Court50 Occam RoadGuildfordSurreyGU2 7ABUnited kingdom
4Gorey Rd, Money Little, Arklow, Co. Wicklow, Y14 E284, IrelandGorey RoadMoney LittleArklowCo. WicklowY14 E284Ireland
5Digital Office Centre Swords, Suite 101-103, Balheary Rd, Balheary Demesne, Swords, Co. Dublin, IrelandSuite 101-103Digital Office Centre SwordsBalheary Rd Balheary Demesne SwordsCo. DublinK67E5AOIreland
6Unit 1 - 3 and Unit 6 - 8, EuroWay Industrial Estate, Blagrove, Swindon SN5 8YW, United KingdomUnit 1 - 3 and Unit 6 - 8EuroWay Industrial EstateBlagroveSwindonWiltshireSN5 8YWUnited kingdom
7Abbeytown Rd, Knocknashee, Boyle, Co. Roscommon, F52 K167, IrelandAbbeytown RoadKnocknasheeBoyleCo. RoscommonF52 K167Ireland
8Mulliner House, Flanders Rd, Chiswick, London W4 1NN, United KingdomMulliner HouseFlanders RoadChiswickLondonW4 1NNUnited kingdom
9Sovereign House, Vision Park, Chivers Way, Histon, Cambridge CB24 9BZ, United KingdomSovereign HouseVision ParkChivers Way HistonCambridgeCambridgeshireCB24 9BZUnited kingdom
10Units 1-4 IDA Industrial Estate, Cork Rd, Waterford, IrelandUnits 1-4IDA Industrial EstateCork RoadWaterfordX91 RP79Ireland
11Waterford Industrial Park, Unit 301, Cork Rd, Waterford, X91 WK68, IrelandUnit 301Waterford Industrial ParkCork RoadWaterfordX91 WK68Ireland
12BLACKWOOD HALL BUSINESS PARK, Woodland House, Cornelius Causeway, Selby YO8 5DD, United KingdomBLACKWOOD HALL BUSINESS PARKWoodland HouseCornelius CausewaySelbyNorth YorkshireYO8 5DDUnited kingdom
13Croom Enterprise Centre, Kilmallock Road, Croom, Co. Limerick, IrelandCroom Enterprise CentreKilmallock RoadCroomCo. LimerickA81 YK06Ireland
14Unit 5, Zephyr Building, Eighth St, Harwell Campus, Harwell, Didcot OX11 0RL, United KingdomUnit 5Zephyr BuildingEighth St Harwell CampusDidcotOxfordshireOX11 0RLUnited Kingdom
15Campus do Lumiar, Edifício R, Estrada do Paço do Lumiar, 1649-038 Lisboa, PortugalCampus do LumiarEdifício REstrada do Paço do LumiarLisboa1649-038Portugal
16Medina House, Globe Business Park, Fieldhouse Ln, Marlow SL7 1TB, United KingdomMedina HouseGlobe Business ParkFieldhouse LaneMarlowBuckinghamshireSL7 1TBUnited kingdom
17Unit 6, IDA, Galway Business Park, Galway, H91 W7CP, IrelandUnit 6IDAGalway Business ParkGalwayH91 W7CPIreland
18Unit 1, Vanguard Industrial Estate, Henwood, Ashford TN24 8DH, United KingdomUnit 1Vanguard Industrial EstateHenwoodAshfordKentTN24 8DHUnited kingdom
Sheet1


Thank you for your time in reviewing my question.
 

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.
How about
Excel Formula:
=ISNUMBER(SEARCH(G2,A2))
 
Upvote 0

Forum statistics

Threads
1,223,227
Messages
6,170,849
Members
452,361
Latest member
d3ad3y3

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top