Excel formula to sort email list?

Hi


I have 3 columns


Gender


Name


Email





I want to create two lists to the side of my data which lists peoples email addresses according to their gender.





I know how to sort this just the once by it is constantly being updated so need a formula to add them to the other list as they are updated.


Can anyone help


Thanks
Excel formula to sort email list?
No VBA required to do AutoSort





You can do sort using formulas (like ROW, OFFSET, INDIRECT)





here is a lesson on how to do that


http://file1.net/lesson.asp?id=9


and here is another one


http://file1.net/lesson.asp?id=10





And this is the file for that lesson


http://file1.net/project.asp?id=70





You may need to modify that file with Dynamic names to include the new added rows





search for dynamic in http://www.file1.net to see how you can do that








After all, VBAXLMan is here to feed your Excel needs
Reply:you'll need VBA script to have it automatically update. good luck - that's not an easy thing to learn.





seriously, you can't do that without VBA.





you could try and record yourself updating it manually into a macro and run it and see if that works. It probably won't but you could try it.