Jun 09 2020 11:18 PM
Jun 10 2020 01:41 AM
Afraid that's only manually, Excel has no idea about the genders. If there are many repeating names, you may create dict table which maps James on male and Jane on female, etc. After that VLOOKUP or INDEX/MATCH it to fill the data.
Dec 22 2020 11:48 AM - edited Dec 22 2020 11:49 AM
Cheers and happy holidays!