Need help with Excel functions, To find Gender using IC number Q&A
|
|
 Dec 27 2018, 11:39 AM
Return to original view | Post
#1
|
 
Senior Member
3,158 posts Joined: Oct 2013 
|
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 |
|
|
Dec 27 2018, 02:00 PM
Return to original view | Post
#2
|
|
Senior Member
3,158 posts Joined: Oct 2013
|
QUOTE(Abs0lute @ Dec 27 2018, 01:58 PM) i would be using this if i didnt know the ISODD formula tenkiu....i learn something new todei  |
| Bump Topic Add ReplyOptions New Topic |
| Change to: |  0.0129sec
 0.88
 7 queries
 GZIP Disabled
Time is now: 17th December 2025 - 11:59 PM |
Quote