Extract Gender from I.D. Number

L

LeilaniMerle

New Member
Joined
Jan 26, 2014
Messages
22
Hi all, There has been a post previous to this regarding Extracting I.D. But I cannot seem to access it. Also that Solution has not worked for me.

1) I need to extract the gender (Male, or Female) from I.D. Numbers.

If my I.D is 580803 0162 086
The 7th Number tells the gender.

If that number is anything from 0-4 it is Female
If that number is anything from 5-9 it is Male

I am typing the number directly into a cell with no "I.D." IN front of it. e.g. (5808030162086) then i am formatting cell to number then getting rid of the decimals.

I am using Excel 2010 from Microsoft Office Professional 2010.

2) I seem to be having a problem when copying a formula to a cell, i.e. say from the internet. It will not work. I have ensured that "show formulas" is enabled.

Hope someone can assist me on these issues.
 

Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK
Sort by date Sort by votes
LeilaniMerle said:
It will not work. I have ensured that "show formulas" is enabled.
Click to expand...

Hi, you might to expand on "will not work" - but try formatting the cell you want to place the formula in as general before entering said formula.

Here is one option for the question:


Excel 2012
AB
15808030162086Female
25808035162086Male
35808033162086Female
45808039162086Male
Sheet1
Cell Formulas
RangeFormula
B1=IF(MID(A1,7,1)+0<5,"Female","Male")
 
Upvote 0
FormR said:
Hi, you might to expand on "will not work" - but try formatting the cell you want to place the formula in as general before entering said formula.

Here is one option for the question:

Excel 2012
AB
15808030162086Female
25808035162086Male
35808033162086Female
45808039162086Male

<colgroup><col style="width: 25pxpx"><col><col></colgroup><thead>
</thead><tbody>
</tbody>
Sheet1​

Worksheet Formulas
CellFormula
B1=IF(MID(A1,7,1)+0<5,"Female","Male")

<thead>
</thead><tbody>
</tbody>

<tbody>
</tbody>
Click to expand...
Hi, thanks for your reply.

I have formatted cells correctly. Done everything necessary to show formula. I cut and paste your formula in and press enter. and nothing happens. the formula shows in the cell.

See as follows:

5808030162086
=IF(MID(A1,7,1)+0<5,"Female","Male")

<tbody>
</tbody>

<tbody>
</tbody>

Number cell formatted as Number - Formula formatted as General.

Is there perhaps a problem with my Excel. I have never had this problem before. As a result I cannot check if formula is working or not.

Many thanks for your assistance.
 
Upvote 0
please confirm your number you are checking is in Row 1, Column A
 
Upvote 0
You must log in or register to reply here.

Similar threads

H
  • Question
data extract between sheets For the value entered
Replies
1
Views
145
LazyBug
LazyBug
H
  • Question
Extract Data from Single Cell. Column is Constant. Number of Rows Involved Changes. Number of Rows Within a Single Cell Can be 1 Up to 9
Replies
6
Views
106
helpmeplz_
H
V
  • Question
Request help in extracting mutiple number groups from specific character positions from a varying number size.
Replies
3
Views
134
Fluff
Fluff
gheyman
  • Solved
Extracting a number for a cell
Replies
1
Views
266
dreid1011
dreid1011
C
  • Question
Extracting Number String from a Text String Cell
Replies
9
Views
803
Glenn Kennedy
G

Forum statistics

Threads
1,215,005
Messages
6,122,661
Members
449,091
Latest member
peppernaut

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top