Assalamualaikum.
As per above title, i'm sure a lot of people has came across this topic in daily work or task. Without having a proper knowledge on Excel, may lead us to manually identify the gender one by one. If the data that required to be checked is very few, then it won't take much time. But if it is the other way around, then you are ADVISED to ask Excel to do the work. Why?? Because it SAVE much of your TIME!!
Now, what you have to do is just construct a simple formula in Excel and walla! the result is automatically displayed in just a few seconds.
As to help you understand better about what I was talking about, I've prepared an example with a suitable coding as shown in pic below;
As per above title, i'm sure a lot of people has came across this topic in daily work or task. Without having a proper knowledge on Excel, may lead us to manually identify the gender one by one. If the data that required to be checked is very few, then it won't take much time. But if it is the other way around, then you are ADVISED to ask Excel to do the work. Why?? Because it SAVE much of your TIME!!
Now, what you have to do is just construct a simple formula in Excel and walla! the result is automatically displayed in just a few seconds.
As to help you understand better about what I was talking about, I've prepared an example with a suitable coding as shown in pic below;
Please take note that the formula is not absolute. Different people might apply different formula, depending on individual level of knowledge in Excel.
Hope this help! ;-)
