Need help with Excel functions, To find Gender using IC number Q&A
|
|
 Dec 27 2018, 01:58 PM
|
 
Junior Member
50 posts Joined: Oct 2018 
|
QUOTE(2feidei @ Dec 27 2018, 11:39 AM) my way, not very efficient way 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   |
|
|
Dec 27 2018, 02:00 PM
|
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 |
|
|
Dec 27 2018, 02:04 PM
|
Newbie
0 posts Joined: Oct 2018
|
QUOTE(jmas @ Dec 27 2018, 01:55 PM) Redundant, IF function itself already checks for TRUE/FALSE. Ah thanks. |
|
|
Dec 27 2018, 02:07 PM
|
Junior Member
830 posts Joined: Mar 2010
|
QUOTE(hirano @ Dec 27 2018, 01:57 PM) Can ayam ask u if ayam got excel question in future? will try to help if possible.  |
|
|
Dec 27 2018, 02:12 PM
|
Senior Member
4,703 posts Joined: Mar 2012
|
QUOTE(jmas @ Dec 27 2018, 11:47 AM) simpler formula =IF(ISODD(RIGHT(A1,4)),"MALE","FEMALE") The RIGHT is to capture last 4 digit only.  |
|
|
Dec 27 2018, 02:14 PM
Show posts by this member only | IPv6 | Post
#26
|
Senior Member
1,118 posts Joined: Jul 2008 From: Ur-anus
|
Formula:
=(Didyouassumemygender)? |
|
|
Dec 27 2018, 02:16 PM
|
Senior Member
1,692 posts Joined: Mar 2009 From: Probation?
|
QUOTE(v1n0d @ Dec 27 2018, 11:53 AM) Thank you for recommending a rocket launcher when all he needed was a revolver. TS never ask if he need scalability later on or notif he want to reuse the function multiple times for other purpose then its better to give rocket launcher manatau user how stupid or smart |
|
|
Dec 27 2018, 02:25 PM
|
Junior Member
313 posts Joined: Jul 2009 
|
Why would you even have a stack of IC numbers? lol
|
|
|
Dec 27 2018, 02:27 PM
Show posts by this member only | IPv6 | Post
#29
|
Senior Member
3,197 posts Joined: Mar 2007 From: Kuala Lumpur, Malaysia
|
QUOTE(spacelion @ Dec 27 2018, 02:16 PM) TS never ask if he need scalability later on or not From experience, the latter is more common.if he want to reuse the function multiple times for other purpose then its better to give rocket launcher manatau user how stupid or smart |
|
|
Dec 27 2018, 02:27 PM
|
Senior Member
4,735 posts Joined: Feb 2010 From: ★~Starlight~★
|
QUOTE(hirano @ Dec 27 2018, 01:57 PM) Can ayam ask u if ayam got excel question in future? bukak ja thread..haha |
|
|
Dec 27 2018, 02:41 PM
|
Junior Member
295 posts Joined: Jun 2006 From: JB
|
/k programmers all come out dy.
|
|
|
Dec 27 2018, 02:43 PM
|
|
Newbie
0 posts Joined: Oct 2018
|
QUOTE(jmas @ Dec 27 2018, 11:47 AM) simpler formula last 1 digit is sufficient=IF(ISODD(RIGHT(A1,4)),"MALE","FEMALE") The RIGHT is to capture last 4 digit only. |
|
|
Dec 27 2018, 02:44 PM
|
|
Junior Member
830 posts Joined: Mar 2010
|
QUOTE(agent sawyer @ Dec 27 2018, 02:43 PM) last 1 digit is sufficient haha, ya, overkill abit.Realize afterwards. |
|
|
Dec 27 2018, 02:56 PM
|
Junior Member
11 posts Joined: Jan 2010
|
many expert here..
tumpang a bit can? what if i want to copy specific keyword to other column. let say this keyword always in capital letter eg: asdad adkjald ABCD asd;ak adskak i want to copy that ABCD to other colum |
|
|
Dec 27 2018, 02:58 PM
|
Senior Member
814 posts Joined: Oct 2009
|
QUOTE(rico_n @ Dec 27 2018, 02:56 PM) many expert here.. =MID(target cell, starting position, length of numbers u wanna copy)tumpang a bit can? what if i want to copy specific keyword to other column. let say this keyword always in capital letter eg: asdad adkjald ABCD asd;ak adskak i want to copy that ABCD to other colum In your example, =MID(A1,15,4) coz include spaces If the position is not fixed, can use this » Click to show Spoiler - click again to hide... « Replace the bold part with your target cell This post has been edited by Flame Haze: Dec 27 2018, 03:32 PM |
|
|
Dec 27 2018, 03:04 PM
|
Senior Member
597 posts Joined: Nov 2007
|
QUOTE(Flame Haze @ Dec 27 2018, 11:52 AM) I learnt something today you mean you just learn the RIGHT function? will you be surprised you also learn LEFT function at the same time? Excel is god program for audit work |
|
|
Dec 27 2018, 03:05 PM
|
|
Senior Member
597 posts Joined: Nov 2007
|
QUOTE(agent sawyer @ Dec 27 2018, 12:00 PM) =IF(ISODD(RIGHT(target cell,1))="True","Male","Female") err... that [="True"] part is redundant, no?You're welcome edit: okay, this had been answered and settled This post has been edited by kiasunkiasi: Dec 27 2018, 03:10 PM |
|
|
Dec 27 2018, 03:07 PM
|
|
Senior Member
814 posts Joined: Oct 2009
|
QUOTE(kiasunkiasi @ Dec 27 2018, 03:04 PM) you mean you just learn the RIGHT function? will you be surprised you also learn LEFT function at the same time? Yeah I know how to use RIGHT, LEFT, MID now thanks |
|
|
Dec 27 2018, 03:10 PM
|
|
Junior Member
117 posts Joined: Nov 2018
|
QUOTE(victorian @ Dec 27 2018, 11:31 AM) Hi let’s say I have a pool of data and some of the genders are unspecified in an excel sheet. What excel formulas should I use to find the gender using the IC. Something like “if last digit of IC is odd numbers, Gender = Male” and so on. Tenks guys YOu split the string, and put the sit string into new column, then you test if that new column is odd or evenEzpz Google sheets is better though since it can do real time processing and have more powerful functions This post has been edited by Aud power: Dec 27 2018, 03:11 PM |
|
|
Dec 27 2018, 03:25 PM
|
|
Junior Member
11 posts Joined: Jan 2010
|
my case always position not fixed wan
the formula in the spoiler not werking  QUOTE(Flame Haze @ Dec 27 2018, 02:58 PM) =MID(target cell, starting position, length of numbers u wanna copy) In your example, =MID(A1,15,4) coz include spaces If the position is not fixed, can use this » Click to show Spoiler - click again to hide... « Replace the bold part with your target cell |
| Bump Topic Add ReplyOptions New Topic |
| Change to: |  0.0190sec
 1.05
 6 queries
 GZIP Disabled
Time is now: 18th December 2025 - 02:16 AM |
Quote