Need Help in formula to avoid blank cells

[Ateeb Ali]

Dear Sir
Attached file, I need help in formula where I can avoid blank cells;
the formula currently I am using is;

=+IF(A2<>0,A$1,"")

Its pasted all the way from J2:Q17
It also showing empty space, I need to add some formula to it does not show empty cells, I have mention same in worksheet with highlighted "Required"

 

[bosco_yip]

Try,

1] In I2, copied down :

=COUNT(A2:H2)

2] In J2, copied across and down :

=IFERROR(INDEX($A$1:$H$1,AGGREGATE(15,6,COLUMN($A$1:$H$1)/($A2:$H2>0),COLUMN(A1))),"")

Regards
Bosco

 

[Peter Bartholomew]

Coming soon in Office 365!

= FILTER( heading, datarow )
where 'heading' is the row starting "Needle1" and 'datarow' is a relative reference to a single row of data below it. Because the data is numeric, any blank counts as 0 / FALSE and any number as TRUE. The relevant headings are copied into a contiguous row of cells as a spill formula.

 

[Ateeb Ali]

Dear Sir
I just attached sample workbook, your formula worked perfect but when I changed it to actual placement, its not working, see attached file

Using this formula but not working;

=IFERROR(INDEX($G$3:$N$3,AGGREGATE(15,6,COLUMN($G$2:$N$2)/($A2:$H2>0),COLUMN(G2))),"")

 

[deciog]

Helping

Correct formula

=SEERRO(ÍNDICE($G$2:$N$2;AGREGAR(15;6;COL($G$2:$N$2)-6/($G3:$N3>0);COL(A1)));"")

and copies to other cells

Decio

 

[Ateeb Ali]

Sorry not working, which language is this?

 

[deciog]

Apologies do not translate the formula the language is Portugues Brasil

Follows the attachment

Decio

 

[bosco_yip]

Dear Sir
I just attached sample workbook, your formula worked perfect but when I changed it to actual placement, its not working, see attached file

Using this formula but not working;

Try this in P3, copied across and down :

=IFERROR(INDEX($G$2:$N$2,AGGREGATE(15,6,COLUMN($G$2:$N$2)-COLUMN($G$2)+1/($G3:$N3>0),COLUMN(A1))),"")

Regards
Bosco

 

[Ateeb Ali]

worked perfectly fine, thanks a lot