Need help with Excel functions, To find Gender using IC number 
Dec 27 2018, 01:58 PM
QUOTE(2feidei @ Dec 27 2018, 11:39 AM)
my way, not very efficient way
1.Copy the list into new column
2.Text to column only the last digit into new cell
3. Use if function in the single digit cell, if odd = male, even = female
i would be using this if i didnt know the ISODD formula 1.Copy the list into new column
2.Text to column only the last digit into new cell
3. Use if function in the single digit cell, if odd = male, even = female
Quote
0.0279sec
0.50
7 queries
GZIP Disabled