front cover

At work, we can extract information such as native place, date of birth, age, constellation, zodiac sign, gender and so on from the ID number. Constellation is not directly reflected in the ID number, and it needs to be extracted according to the ID number before processing. So, today I want to share with you the information of extracting constellations, hoping to help you.

There are no two identical leaves in the world, and there is no difference between two people. Each of the twelve constellations has its own unique personality characteristics. If you can understand in advance, you will get along more harmoniously, reduce differences and understand more. Constellations are related to the month and date of birth. If you don't use other tables to query, you can also use a combination of lookup and array functions.

operational approach

Use function: find, MID

First, enter the MID function, enter the truncated cell D3, and enter the number truncated from bit 1 1

Enter the number of characters with truncation length of 4, and the formula =MID(D3, 1 1, 4).

Then, the search function is combined with the array to find and match.

Finally, move the cursor to the lower right corner of the cell and it will turn into a black+sign, and then double-click Quick Fill.

operational approach

The complete formula is as follows: = lookup (-mid (d3, 1 1, 4), {100; 120; 2 19; 32 1; 42 1; 52 1; 622; 723; 823; 923; 1023; 1 122; 1222} {Capricorn; Aquarius; Pisces; Aries; Taurus; Gemini; Cancer; Leo; Virgo; Libra; Scorpio; Sagittarius; Capricorn})

If the above functions have problems in use, you can directly copy the formula into the cell, and then modify the D3 cell in the formula into the cell where the ID card is located.

It's that simple. Have you learned? If you have other better methods, please leave a message and communicate with us so as to make progress.

Lunar birthday constellation query

How to find out what constellation relatives are born in lunar calendar or solar calendar? Constellations are divided by the dates of the Gregorian calendar (Gregorian calendar and new calendar). First, you have to know your date of birth in the solar calendar, and then compare the following information. Inquiries about the Gregorian calendar and the lunar calendar can be made through the online electronic calendar. Aries March 2 1-April 19 Taurus April 20-May 20 Gemini May 21-June 21Cancer June 22-Date-65438+1October 23 Scorpio 65438+ 1October 20th-February 18 Pisces February19-March 20th Lunar Birthday How to check the constellation is determined by the Gregorian calendar date, as long as there is a birthday in the Gregorian calendar. If it's a lunar birthday, it's necessary to convert it into a solar day according to the year, and then query the constellation. You fill in the year. I can help you. How to find out what constellation, whether it is a lunar birthday or a solar birthday, is divided according to the birthday of the solar calendar (new calendar, Gregorian calendar) in the year of birth? The following is a constellation date division table. Compare the birthday in the solar calendar with the one below, and you will know what constellation it is. Aries (03/2 1-04/20) Taurus (04/2 1-05/20) Gemini (05/21-06/2/) Cancer (06) 23 If you only know the birth date of the lunar calendar, you can convert it into the birthday of the solar calendar before entering the information. Aries: March 2nd1to April 20th Taurus: April 2nd1to May 2nd1Gemini: May 22nd to June 2nd1Cancer: June 22nd to July 22nd Leo: July 23rd to August 23rd Virgo: August 23rd. Sun ~165438+1October 22nd Sagittarius:165438+1October 23rd ~ 65438+February 20th Capricorn: 65438+February 22nd ~ 65438+/ The two are slightly different. If your birthday is near the boundary date and you are not sure, please enter your birth data here and draw your personal astrolabe, in which the constellation where the sun is located is what we usually call the constellation. The quartering divides the constellation into four fire signs according to fire, earth, wind and humidity: Aries, Leo and Sagittarius; Taurus, Virgo, Capricorn; Gemini, Libra, Aquarius; Cancer, Scorpio, Pisces; Fire signs are full of energy, passion and action, but sometimes they come and go in a hurry. People in earth signs are cautious, calm, sincere and persistent in feelings, and down-to-earth in their work, but sometimes they are too conservative and have low self-confidence. Air signs's people are developed in thinking, rich in imagination, inclined to thinkers, good at socializing and strong in language expression, but their personalities are changeable, they like the new and hate the old, and they are emotional. Water sign people are gentle and quiet, with delicate feelings, and have strong insight and sensitive intuition about things, but sometimes their ideas are unrealistic and they like to be emotional. Generally speaking, in the four categories of fire, earth, wind and water, fire and wind get along well, and land and water get along well. As the saying goes: wind helps fire. People in air signs are calm and rational, while people in fire sign are passionate and impulsive. When these two people are together, people in air signs often use spindles to assist people in the fire sign, and they often give instructions in action. People in the earth sign are emotionally stable for a period of time, while people in the water sign are emotionally sensitive and volatile, so people in the earth sign tend to care for and comfort people in the water sign, thus forming an auxiliary relationship emotionally. In addition, I will give you two other constellation allocation methods: 1. The dichotomy divides constellations into two categories according to masculinity and femininity: masculinity: Aries, Gemini, Leo, Libra, Sagittarius and Aquarius. Female: Most people who own Taurus, Cancer, Virgo, Scorpio, Capricorn and Pisces are enterprising and proactive idealists. Most people with negative signs are introverted and passive strategists. Second, the trichotomy divides the constellations into three categories according to the standard type, fixed type and flexible type: standard type: Aries, Cancer, Libra and Capricorn, and these constellations belong to the leader type. Fixed type: Taurus, Leo, Scorpio and Aquarius, all of which belong to the organizer type. Variants: Gemini, Virgo, Sagittarius, Pisces. This long constellation belongs to the gift-giving type. Among these three classifications, the quartering method is the most commonly used, because it contains the dichotomy (fire and wind are positive, and earth and water are negative), and its display is also obvious, which can be used as the basic classification of ordinary people. Woman: ... how to calculate the constellation on the lunar birthday? The date of the lunar calendar is different from the date of the solar calendar every year, so you must convert the lunar calendar of Nyan, where you were born, into the solar calendar. Look it up according to the horoscope. 1992, the ninth day of the twelfth lunar month, is the Gregorian calendar 1 99365438+1October1Capricorn (12/22-120) Capricorn ~ stable and practical personality. Usually, they are very strong, have extraordinary endurance, strong will, sense of time and responsibility, attach importance to authority and reputation, have good control ability to leaders, find a new way and have good organizational skills. The following is the date of birth of the constellation. Lunar constellations are different from our zodiac signs calculated by the lunar calendar method, but are determined by the solar calendar. Therefore, you have to change the birthday of the lunar calendar to the birthday of the solar calendar to know what constellation it is. 1 1992 The corresponding Gregorian calendar (Gregorian calendar) is 1 1992. The constellation corresponding to this birthday should be Sagittarius. Aquarius: 65438+1October 2 1 ~ February19 (February also has 18 days) Pisces: February 20 ~ March 20 Aries: March 21~ April 20. July 23rd to August 23rd Virgo: August 24th to September 23rd Libra: September 24th to 65438+1October 23rd Scorpio: 65438+1October 24th to165438+1October 22nd. Constellation is determined by the Gregorian calendar date, and the Gregorian calendar date should be used to query the constellation. If the lunar calendar date is used, the corresponding year should be provided so that the lunar calendar date can be converted into the solar calendar date for query. Please specify your date of birth (lunar or solar calendar) and I can help you. Constellation query lunar birth date 1989 1028 is Scorpio (10.24 ~11.22) Constellation query is lunar calendar or new calendar? The zodiac generally refers to the position where the sun passes through the zodiac 12 when we are born. So the constellation we often say refers to the sun constellation. Generally speaking, the Gregorian calendar (solar calendar) is faster for the sun constellation. Common constellation Gregorian calendar date: Aries: 3/2 1-4/20 Taurus: 4/2 1-5/20 Gemini: 5/2 1-6/2 1 Cancer: 6/22-7/22. 23-1121Sagittarius:11/22-121Capricorn:12/20. Because of precession, sometimes it will be one day earlier or one day later. In addition to the sun sign, there are also the moon sign and the rising sign, which refer to the position where the moon passes through the zodiac 12 and the zodiac 12 where the eastern horizon is located when we were born. Constellations are calculated according to the lunar birthday or the national birthday. Constellations are divided according to the solar calendar (national calendar). According to your birthday in the year of birth, here are the twelve constellations for your comparison. Constellation name, constellation date, constellation attribute, xìng number, lucky color, Aries 03/2 1-04/ 19 fire sign 6. Taurus 04/20-05/20 Xiang constellation 1 9, purple, Gemini 05/2 1-06/20 air signs 3, 5, 7, light pink, Cancer 06/2 1-07/22 water sign 8, 3. 8, yellow, Libra 09/23- 10/22 air signs 6, 9, orange, Scorpio10/23-11water sign 3, 5, dark gray, dark. Capricorn12/22-019 Earth signs 3, 7, scarlet, Aquarius 0 1/20-02/ 18 air signs 4, 8, golden yellow, Pisces 02/.

How to check your horoscope?

Step 1: First, check how long your lunar calendar is online. Secondly, compare your horoscope, open the perpetual calendar and find your own lunar calendar.

Step 2: Now compare the constellations according to the lunar calendar you found.

Step 3: Tell everyone the specific time of each constellation.

According to these times, you can find your own constellation.

1 Aries: March 2 1 to April 19.

Taurus: April 20th to May 20th.

3 Gemini: May 2 1 ~ June 21

4 Cancer: June 22nd to July 22nd.

Leo: July 23rd to August 22nd.

6 Virgo: August 23rd to September 22nd.

Libra: September 23rd ~ 65438+1October 23rd.

Scorpio: 65438+1October 24th ~165438+1October 22nd.

9 Sagittarius:165438+1October 23rd ~ 65438+February 2nd1.

10 Capricorn: 65438+February 22nd to 65438+1October 19.

1 1 Aquarius: 65438+1October 20r ~ month 18

12 Pisces: February19 ~ March 20th.

Is the constellation calculated by lunar calendar or solar calendar?

When inquiring about constellations, people will definitely struggle whether to use the lunar calendar or the solar calendar. Constellation originated from western astrology, and the calendar used in the west is solar calendar, so it is solar calendar, that is, the date that passes quickly. The twelve constellations were originally used for testing, and each pronoun represents a certain position in the universe. Later, people used to put the twelve constellations on behalf of twelve personalities. The birth time of each person, that is, the location of the ecliptic of the satellite, implies a person's innate character. The twelve constellations can reflect a person's psychological characteristics and symbolically represent a person's life behavior. Finally, the zodiac is divided into twelve constellations, which are called the twelve constellations of the zodiac, that is, the twelve constellations.

The above is the knowledge about the lunar constellation table, 1- 12, and we will continue to sort out the knowledge about the lunar constellation query for you later, hoping to help you!