Look at the following screenshot, There is column A (A1:A15) and column C (C1:C13) which contain some duplicate names. By using a formula, we can compare two columns and display the duplicate values. Please do with the following steps: 1  In cell B1, input this formula: â=IF(ISERROR(MATCH(A1,$C$1:$C$13,0)),,A1)â.ook at the following screenshot, There is column A (A1:A15) and column C (C1:C13) which contain some duplicate names. By using a formula, we can compare two columns and display the duplicate values. Please do with the following steps: 1  In cell B1, input this formula: â=IF(ISERROR(MATCH(A1,$C$1:$C$13,0)),,A1)â.
Of the five or so mass extinctions recorded in Earth's fossils, this one at the end of the Permian period and the start of the Triassic was the most catastrophic. More than half of the families of living things died out, and as many as 90 to 96 percent of the planet's marine species were lost.At the same time, perhaps 70 percent of the land's reptile, amphibian, insect, and plants species went extinct.he Permian layers contain abundant animal fossils and fossilized traces of animals, while the Triassic layers are almost devoid of fossils, suggesting a mass extinction event occurred 250 million years ago, at the end of the Permian. Credits: 2001 WGBH Educational Foundation and Clear Blue Sky Productions, Inc.
The Devonian Extinction. Toward the end of the Devonian, nearly 70% of all invertebrate species vanished during the Late Devonian extinction. Marine species (especially tropical ones) suffered the most extinctions, followed by freshwater species, whereas terrestrial species were hardly affected.he Devonian Extinction. Toward the end of the Devonian, nearly 70% of all invertebrate species vanished during the Late Devonian extinction. Marine species (especially tropical ones) suffered the most extinctions, followed by freshwater species, whereas terrestrial species were hardly affected.