Function GetSex

GETSEX() Description

The GETSEX() function returns the sex (gender) indicator (male/female/undefined) by analyzing the first name, last name, and patronymic.

Names can be written in Ukrainian, English, and Russian languages.

Key Features of the GETSEX Function

Syntax:

=GETSEX(Name)

Parameters:

• Name: Cell with the person's name.

Example Usage

The GETSEX() function is easy to use. You just need to specify the cell with the person's name, and Excel (Calc) will automatically determine their sex:

=GETSEX(Name)

We will get the following result:

The following values are used in this example:

• Name: A3 - Cell containing the person's name ("John Brown").

Download extension

You can use the GETSEX() function by installing the YLC Utilities extension.

After this, this function will be available in all files that will be opened in Excel (LibreOffice Calc).