Hi friends
i hope you are doing well
i’m pasing through a big challenge of simplify may work here for a long time.
I have a data in sheet 1 to sheet 3 and i have the sheet named male and another sheet named female.
I need a formular to sort data from sheet 1 to sheet 3 by considering column i where by there is number(total marks) in each sheet. I need to get out the first 10 highest numbers with their names from all work sheets to be in sheet named female. In column d there is number 1 and 2. Number 1 stand for male and number 2 stand for female.
I need also to get out the first 10 highest numbers with their names from all work sheets to be in sheet named male. In column d there is number 1 and 2. Number 1 stand for male and number 2 stand for female.
I’m beg anyone who have an idea to help me. Thanks a lot
see the attached file
Bookmarks