Fortune Telling Collection - Horoscope - I entered a lot of students' information in the form, including birthdays, and now I want to make a program for excel to automatically get out each student constellation.
I entered a lot of students' information in the form, including birthdays, and now I want to make a program for excel to automatically get out each student constellation.
Suppose the birthday is in A 1.
B 1 Enter the following formula to get the constellation:
=LOOKUP( - TEXT(A 1," mm.d "),{ 1.0 1. 1,2. 19,3.2 1,4.2 1,5.2 1,6.22,7.23,8.23,9.23, 10
- Related articles
- Baidu knows, who plays Tang Youyou? Do you still get along?
- Is pretending to be innocent the best thing for Gemini girls?
- Twelve Constellation Exclusive Flowers _ What is the Twelve Constellation Exclusive Flowers?
- What is the palace divided according to? Does each constellation have a corresponding house?
- What is the relationship between the elves in The Hobbit: The Battle of the Five Armies?
- You can't leave them without a few words. What are the constellation men who are single-minded about lions and girls?
- The reaction of the twelve constellations in danger
- A little overwhelmed, how do Scorpio girls deal with their boyfriends coquetry?
- Constellation Room _ Constellation Room Diagram Bedroom Picture
- Do the three ugliest constellations have much to do with personality?