formulas not working

[fady77]

dear all
I would appreciate your help in this matter i have a working sheet "DATA ENTRY" where all thee entered data will be displayed on another sheet according to a cell value
i used the below formula
=IFERROR(INDEX('DATA ENTRY'!T:T,AGGREGATE(15,6,ROW('DATA ENTRY'!$A$7:$A$10000)/(('DATA ENTRY'!$A$7:$A$1000=$A$7)*('DATA ENTRY'!$S$7:$S$10000=$S10)),COUNTIF($S$10:$S10,$S10))),"")

but for some reason the formula is not working well because some of the data i previously entered are not showing

if you could see in the attached file the "EMPLOYEE DATA" where all the formulas are written only in the columns T U V W in some rows the data is not showing as it should as the others cells
I really appreciate your help in this matter

 

[Fluff]

Looks as though this part of the formula is wrong 'DATA ENTRY'!$A$7:$A$1000=$A$7it's only going to row 1000, rather than row 10,000

 

[fady77]

thank you what a silly me i couldn't see the 0
really appreciate your help

 

[Fluff]

You're welcome & thanks for the feedback.

 

[fady77]

sir one more thing how can i remove thereturning value (0) from the cells that are blank
i tried to add the ISNA but it didn't work or maybe i place it in the wrong way

 

[Fluff]

Is the formula returning text, numbers, or possibly both?

 

[fady77]

actually it is returning both but i used another way where i changed the options of the sheet where i Hide the Zero
but if you clould help me to modify the fractions i would be greatfull for you

 

[Fluff]

What fractions? I have no idea what your formula is meant to return.

 

[fady77]

i tried to upload the file so u can have a proper idea but i couldn't
It is ok Bro i will keep it as it is and use the options
thank you for your great hlpe i appreciated

 

[Fluff]

You're welcome & thanks for the feedback.