Hi
many thanx
I am trying the index and match function and succeeded partly but ran into an issue when it needed to reference numerics
Could you so kindly point out where my eror is so that we can fix
Thank you in anticipation
Yours kindly
Rajan
Hi
many thanx
I am trying the index and match function and succeeded partly but ran into an issue when it needed to reference numerics
Could you so kindly point out where my eror is so that we can fix
Thank you in anticipation
Yours kindly
Rajan
Hi
many thanx
My version of excel is 2019
Regards
rajan
Greetings
I am trying to get my cells here on the sheet to be able to look at a character and read off a value
Also to read a numeric contents and read off a value
its doing it for charcters but not numbers
thanx in anticipation
Rajan
Greetings thank you for the formula its working , however from the chines table, there seems to be a problem not with your formula, but I think the way it was explained and my Malasian friend said the way the Indians work it out is not based on the chinese almanac
I included the table, will there be a way to write formula that will be able to read from the table
and indicate the kua number and its direction
Kind regards
Rajan
Thank you so much for your time guidance and help always appreciate it
Rajan
Hi
yes I can work on a sample sheet and i would appreciate feedback and corrections from you
will do so
thank you
rajan
Hi
This is the link where a formula may be found
Kua Number for Male:
1. Add the last two numbers of your year of birth. If it's 0, use 10 instead.
2. Then, subtract 1 from the number you get if you were born before the Chinese Lunar New Year. (Simply use the Chinese calendar to check if your birthday is before the New Year). If were born after the Chinese Lunar New Year, just skip this step and go on.
3. As the result needs a single digit, if you already got a single digit, go to the next step. If it contains two numbers, you need to add the numbers you get together.
4. If you were born before 2000, subtract the single digit you get from 10. If you were born after 2000, subtract the single digit from 9. If the result is a double digit, then add the digits to get a single digit number. Then you get your Kua number finally.
Kua Number for Female:
1. Add the last two numbers of your year of birth. If it's 0, use 10 instead.
2. Then, subtract 1 from the number you get if you were born before the Chinese Lunar New Year. (Simply use the Chinese calendar to check if your birthday is before the New Year). If were born after the Chinese Lunar New Year, just skip this step and go on.
3. As the result needs a single digit, if you already got a single digit, go to the next step. If not, you need to add the two digits together to get.
4. If you were born before 2000, add 5 to the single digit. If you were born after 2000, add 6 instead. If the result is a double digit, then add the digits to get a single digit number. Now, you get your Kua number finally.
Take a man born in 01/16/1982 for an example. The formula is:
● 8+2=10
● As the Chinese New Year of 1982 started from Jan. 25, 1982, his birthdate is before the New Year: 10-1 = 9
● 10-9=1
Result: 1 is the Kua number for the man.
it also has tables
regards
raj
Hi
Found this interesting link
may help in trying to devise a formula
Rajan
Hi
Thank you so much for the links makes interesting reading
I was looking for a way that my spread would be able to convert now realise its not that
easy
Probably the only way would be to do it manually and then add into the spreadsheet
its very interesting because in the western way amy friends kua number was 4 but in the chinese calender his kua number is 3
its to do with the lunar calendar and the west always start1 st january but the chinese can be mid jan early feb
Thanx a span for the links I have learnt
regards
Rajan
Hi
I am trying to understand that there is a difference the way chinese calculate thei r new year
the Chinese method, if anyone is born before the 1st 10 days of Feb, he or she belongs to the previous year.
Western Calender: 1st Jan to 31st Dec.
Chinese Year: Any dates between late Jan or 1st 10 days of Feb. To the next year Jan-Feb (1st 10 days Feb).
The 12 months are shifted to start in late Jan or Feb.
Eg a person born on 11 Jan 1965, his Chinese date is 16 Dec 1964. So the Kua number has also changed. So the accuracy is out.
is there a way that a formula can be used to achieve this
Thank you in anticipation for the help
kind regards
rajan
Hi I am attaching a file I need help with a formula that will be able to split a name with middle name and surname that is separated by a space
say for exampla in the cell the following name will appear
Geetangali Angali Singhpaul
to be separate as follows
g e e t a n g a l i a n g a l i s i n g h p a u l
the firstname would be to a max of 2 o characters and the mid space surname to be max 40 characters
Thank you in anticipation
Regards
Rajan
Hi Sir
many thanx solution solved
Thanx a span
The formula for Y13 is called in from BF 1
its in addition if the D D is greater than 0
Regards
rajan
Greetings Sir
I just discovered that I have a further challenge that in the example AN1 plus AO1 , the sumtotal would be 5, we need to check in row R12 if it matches, pate the the value into R13 |
I removed the old formula from R13
May you please help with a formula to do the above many thanx rajan |
Hi Sir
Also I would like to thank for all your help and guidance in helping find solutions
The most is that I am also learning how to use and apply formulae
At any time if you would like a grid made for you
I will be most honored to do
Once again
Many thanx and regards
Rajan
Hi
Many thanx for the kind words
The grid did originate from China
Now in India its used a branch of numerology
Have started learning to use the grid
Thank you once again
Rajan
Hi Sir
Amazing solution
My humble apologies for being the cause of you having to take aspirin
I am extremely grateful for the help
Sir do let me know if this grid will be of use to you
Regards
Raj
Hi
many thankx much appreciated
Regards
Rajan