Copying formulas in excel - No change to cell reference

-
If you dont want the cell references to change when you copy and paste your formulas use $ signs.

example:
=$A1&B2.

this will not change A's row, only columns.

=$A$1

will not change both row or column

Comments

Post a Comment

Popular posts from this blog

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...
Read more

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")
Read more

English Words that have originated from Tamil

-
Here is a list of 100+ words that have some root in Tamil language machila a hammock slung on a pole used for carrying passengers in many parts of Africa Portuguese, perhaps from Tamil macil, mañcil stage in a journey, from Hindi manzil, from Arabic mamoty a hand tool used for digging and cultivating in southeastern Asia Tamil mammaṭṭi, alteration of maṇ-veṭṭi, from maṇ earth + veṭṭi spade sandalwood the compact close-grained fragrant yellowish heartwood of a parasitic tree (Santalum album of the family Santalaceae, the sandalwood family) of southern Asia much used in ornamental carving and cabinetwork sandal sandalwood (from Middle English, from Anglo-French sandali, from Medieval Latin sandalum, from Late Greek santalon, ultimately from Sanskrit candana, of Dravidian origin; akin to Tamil cāntu sandalwood tree) + wood entry 1 Gurmukhi the alphabet that the sacred texts of the Sikhs in whatever lan...
Read more