Excel - Validate from a List

-
need to have a formula check whether or not a particular value occurs


within a range of data. For example, given the data set below:

A

1 red

2 yellow

3 green

4 blue



I need to be able to check whether that list contains a particular word. So

something like: =ifcontains(A1:A4,"green","Yes","No"). So in this case, the

"ifcontains" function would give me a "Yes", and

=ifcontains(A1:A4,"orange","Yes","No") would evaluate to "No".

Solution

B1 = green




=IF(COUNTIF(A1:A4,B1),"Yes","No")

Comments

Post a Comment

Popular posts from this blog

Garden Tourism festival - New Delhi

-
Image
When:           End of Feb every year Venue : Garden of Five Senses The Garden Tourism Festival is organized by the Delhi Tourism department in the end of February. It stretches on for three days. Garden Tourism Festival features some of the most exotic varieties of flower like roses and dahlias, potted plants, bonsai, home plants, etc. The festival is the right destination for flower enthusiasts. Apart from the display of flowers, it has a number of other attractions also. These attractions include painting competitions for children and a number of cultural shows to amuse the visitors. And if you are fond of gardening, then you can meet a number of people at the Garden Tourism Festival, who share the same interest.  The Garden Tourism Festival of New Delhi offers a nature lover an opportunity to get closer to nature amidst the commotion of the busy city life. It was with this sole intention that the Garden Tourism Festival was started in 2004. With the app
Read more

Arab World - countries, map and rulers

-
Image
Arabs are] A people/ethnicity/nation, including a culture, language and religion, that originated in the 7th century western Arabian peninsula, and was spread to almost all the aboriginal semitic peoples of the near east by conquest and forced conversions to Islam. Arabs are Muslims or are descendants of Muslim Arab ancestors (since it has always been illegal for an arab to convert to any other religion, the rare non-Muslim Arab is usually an atheist); Arabic is a  Semitic language  of the Arabo-Canaanite subgroup (Ruhlen 1987). With approximately 186 million speakers, it ranks in sixth place among the world’s major languages, behind Mandarin Chinese, Hindi, Spanish, English and Bengali. list of current dictators: http://www.planetrulers.com/current-dictators/ Algeria Bahrain Djibuti Egypt Jordan Kuwait Iraq Jordan Lebanon Libya Mauritius Morocco Oman Qatar Saudi Arabia Somalia
Read more

Muslim Populace around the world

-
Image
This community consists of between 1.2 and 1.6 billion people, or roughly one-fifth of mankind. This diaspora is spread across many different nations and ethnic groups connected by religion and a shared sense of belonging.  With the exception of India, Ethiopia, China and Russia the majority of the population in the following countries are Muslim. Indonesia 202,867,000 (88.2%) Pakistan 174,082,000 (96.3%) India 160,945,000 (13.4%) Bangladesh 145,312,000 (89.6%) Egypt 78,513,000 (94.6%) Nigeria  78,056,000 (50.4%) Iran 73,777,000 (99.4%) Turkey 73,619,000 (98.0%) Algeria  34,199,000 (98.0  %) Morocco 31,993,000 (99.0%) Iraq  30,428,000 (99.0%) Sudan  30,121,000 (71.3%) Afghanistan 28,072,000 (99.7%) Ethiopia 28,063,000 (33.9%) Uzbekistan 26,469,000 (96.3%) Saudi Arabia 24,949,000 (97.0%) Yemen  23,363,000 (99.1%) China 21,667,000 (1.6%) Syria  20,196,000 (92.2%) Malaysia  16,581,000 (60.4%) Russia  16,482,000 (11.7%) Niger  15,075,000 (98.6%)
Read more