Fiter function not bringing back all data

[SantanaKRE8s]

Hello Im using the filter function but something is wrong in the spill, its missing data, its only bringing back the first row complete. Can someone please help,

=FILTER(TTI!D36:M4600,TTI!$D36:D4600=B36,"NOT FOUND")

 

[Fluff]

Check that you don't have any cell or conditional formatting that is changing the font colour.

 

[SantanaKRE8s]

Check that you don't have any cell or conditional formatting that is changing the font colour.

I removed the conditional formatting in my column D, I looked into the XL2BB but I dont have that add ins, It could be restricted by my company IT

 

[Fluff]

As it appears that only some cells are not showing, it's not the formula. Therefore it must be formatting of some sort.

 

[SantanaKRE8s]

As it appears that only some cells are not showing, it's not the formula. Therefore it must be formatting of some sort.

I agree with you, it used to work, I do use conca function but now I converted the result from conca to value and now its not bringing back any data at all. I added the conca function again and the filter starts working again but yes not bringing all the rows just the first one.

 

[Fluff]

From your image the 1st & 4th col are returning all the rows & there fore the other columns must be as well, assuming you are just putting the formula into a single cell, rather than dragging it.

 

[SantanaKRE8s]

From your image the 1st & 4th col are returning all the rows & there fore the other columns must be as well, assuming you are just putting the formula into a single cell, rather than dragging it.

Yes Im putting the formula in a single cell, When I do the drag it it does not work at all. Im checking the sheet is filtering the data but I no loger have any formatting.

 

[Fluff]

Yes Im putting the formula in a single cell

In that case all the data is there.

 

[SantanaKRE8s]

In that case all the data is there.

It should be four row of data,

 

[Fluff]

The image you originally posted shows that there are 4 rows being returned.