Fortune Telling Collection - Horoscope - Excel table how to make constellation formula according to ID card?
Excel table how to make constellation formula according to ID card?
The ID number starts from column C C2, please enter the formula in D2:
= lookup (-text (C2, "MDD"), {10 1, "Capricorn"; 120, "Aquarius"; 2 19, "Pisces"; 32 1, "Aries"; 420, Taurus; 52 1, "Gemini"; 62 1, cancer; 723. Leo; 823, "Virgo"; 923, Libra; 1023, Scorpio; 1 122, "Sagittarius"; 1222, Capricorn).
Drop-down fill.
- Previous article:The constellation of February 16.
- Next article:What is the principle of water clock?
- Related articles
- Who can drink the most in the twelve constellations _ Who can drink the most in the twelve constellations?
- What is the constellation of 2000424 _ What is the constellation of 2000424?
- Once you get hurt, you will increase your counterattack.
- In the zodiac, you accidentally angered Aries. What can you do to make Aries forgive you?
- Meng Xueyuan Season 4 Restore Teng Episode 1
- Leo and Aquarius
- Divide the whole day into several constellation areas
- Birthday Destiny: 1 1 What is the constellation on March 3rd?
- A landlubber can't swim no matter how he learns.
- Constellation girl who regrets after doing something.