Auto Serial in Filter Data Excel?

[kashifundlas]

For Example hamaray pass aik worksheet mein 100 rows han or oss mein aik column male & female ka hai (50 male & 50 female).. ab hum issi worksheet ki copy ker kay filter laga ker male alag ker letay han.... jab hum male alag kertay han filter laga ker to ab ye male wali list ko auto serial kaisay laga saktay han.. worksheet jiss mein 100 han oss mein to easily auto serial lag jati hai 1,2,3 and so on.. but ye filter walay ko q nahi lagti..

[kashifundlas]

plz help.......

[Nazik Abbas]

attach your worksheet

[sittarah]

Filter walay ko kisi aur work sheet main copy karain aur auto serial laga kr wapis dono column paste kr dain because I think its not possible to make auto serial in filter.

[kashifundlas]

same problem with me..... any expert here please