# Posts by khanaran

• ## allocate a value that reads from the cell

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

• ## allocate a value that reads from the cell

Hi

many thanx

My version of excel is 2019

Regards

rajan

• ## allocate a value that reads from the cell

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

its doing it for charcters but not numbers

thanx in anticipation

Rajan

• ## Formula to convert a gregorian date to a chinese date

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

• ## Formula to convert a gregorian date to a chinese date

Thank you so much for your time guidance and help always appreciate it

Rajan

Hi

KInd regards

rajan

• ## Formula to convert a gregorian date to a chinese date

Hi

yes I can work on a sample sheet and i would appreciate feedback and corrections from you

will do so

thank you

rajan

• ## Formula to convert a gregorian date to a chinese date

Hi

This is the link where a formula may be found

Feng Shui Directions Chart & Calculator, Find Your Lucky Directions by Kua Number, Gua Number (yourchineseastrology.com)

### How To Calculate Feng Shui Kua Number?

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

• ## Formula to convert a gregorian date to a chinese date

Hi

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

• ## Formula to convert a gregorian date to a chinese date

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

• ## Split a name enter in a cell into separate cells , separated by firstname midname space surname

Hi Sir

Many thanx

Solution brilliant

Regards

Rajan

• ## Split a name enter in a cell into separate cells , separated by firstname midname space surname

hi

Many thanx for the solutiuon

I am trying but am doing something incorrect

Rajan

• ## Split a name enter in a cell into separate cells , separated by firstname midname space surname

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

• ## Match a value against a date and enter the matched value

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

• ## Match a value against a date and enter the matched value

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 abovemany thanxrajan
• ## Match a value against a date and enter the matched value

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

• ## Match a value against a date and enter the matched value

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

• ## Match a value against a date and enter the matched value

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

• ## Match a value against a date and enter the matched value

Hi

many thankx much appreciated

Regards

Rajan