Excel- Male/ Female Auto Calc

[Taang Sianpu]

A nuai a mun ah a dang teng bel lem lel sam. Ahih hang akisam lai khat ah Sangnaupang tampi a om hi leh, tua mun ah sangnaupangte i list sung ah F/ M (Male, Female) gelh ding kisam. Ahih hang in Excel file sung ah F leh M gelh ding in tua pen a nuai or a pang mun khat ah F-Bangzah, M-Bangzah cih auto in suaksak ding. Tua formula a thei i om leh ong hawmsawn un. Lungdam khawl mahmah ingh.

[moemangsen]

Hihpen Array Formula tawh kibawltheiding hiveh aw. Hun ngahsim pianin test kawikawileng senpi thei lengding hiveh.

Ahihhang lawlawse, Data - Sort tawh Female or Male choose in, a result teng gamlecinzong kingahding hiven. Kikum toto niei, excel zong a formula lamah thuklutleng ana thupi mahmahkhat himawk mah ei.