Compare paragraphs

Clmarcela

New Member
Joined
Dec 4, 2014
Messages
2
Dear All,


As you can see below, I have five descriptions or paragraphs.

No.
Description
1
Media sources indicate that a fire at the Tihange 3 nuclear power plant has shut down the reactor. The fire is reported to be electrical cables, and there is no reported danger from fissile material. Fire crews are responding. Tihange 3 has an electricity capacity of over 1,000 megawatts.
2
Strike action by unions protesting planned pension and social security reforms have disrupted rail services in parts of Western and Eastern Belgium on Monday 1 December. Connections to and from Ghent, Bruges and Liege have been worst hit. International rail services have also been affected, with Deutsche Bahn and Thalys services between Belgium and Germany suspended, and no CFL trains running to and from Luxembourg. Eurostar services to London were operating normally today, however there will be no trains running on 8 and 15 of December when further strikes will affect Brussels. Travellers should consider amending travel plans, taking into account the level of disruption caused by the strike action.
3
Reports indicate that Belgium's Tihange 3 nuclear power station has been automatically shut down following a fire that broke out at the plant on Sunday 30 November. The fire reportedly started following an explosion, and has since been extinguished. It is unclear at this time how long the plant will remain shut down. Travellers in the area should expect possible power outages while Tihange 3 is out of service.
4
Media sources indicate that 17,000 people are being evacuated from an unspecified area in Dortmund due to a recently-discovered 1.8 ton bomb from WWII. A 1.5 kilometer exclusion zone has been set up, and the bomb is planned to be made inert at 12:00 PM local time.
5
General strikes in the Belgian provinces of East Flanders, West Flanders, Liege, and Namur has led to the disruption of cargo transport at a number of facilities, including the ports of Zeebrugge and Ghent. Delays were also reported a Liege Airport, the primary European cargo hub for a major Dutch courier service and a number of Middle Eastern and African air cargo carriers. Lines of picketing protestors prevented access to the ports of Ghent and Zeebrugge. Disruptive protests were also reported at industrial or business parks in several parts of Liege, including Herstal, Villers-le-Bouillet, Grace-Hollogne, and Sart-Tilman.

<TBODY>
</TBODY>

The descriptions which have similar content are:

Descriptions number 1 and 3 are related to nuclear information.
Descriptions number 2 and 5 are related to strikes information.
Description number 4 is not similar or does not match with the other descriptions.

I need a macro or function that help me to identify automatically the matching descriptions according to the text content.

Best regards
 

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying

Forum statistics

Threads
1,214,943
Messages
6,122,369
Members
449,080
Latest member
Armadillos

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