i have a mixed list of 200 boys and girls and their marks. My problem is how do i extract two separate lists one for boys and the other for girls sorted with the best on top.
i have a mixed list of 200 boys and girls and their marks. My problem is how do i extract two separate lists one for boys and the other for girls sorted with the best on top.
Hi,
Is that all you have, or do you have other relevant information like a field for '***' with perhaps M/F in it?
If not, then short of you creating a list of allowable girls & boys name I can't see how Excel has anything to work with in terms of logic.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
lol Richard said a bad word![]()
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Hi,
Yes I completely forgot about the nanny tendency of the forum. Maybe I should have said 's e x'. - wonder if that will be edited...![]()
nope, that went though just fine![]()
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks