Column width displaying data as required......

[damian_r_Home]

Morning All.

Having had some fantastic help from a forum member yesterday whi never gave up on my problem even when I was ready to (thanks Etaf), i wonder if somebody could help me with the following.

I have a page which now looks like this - which does eaxctly what i need it to do with getting data from elsewhere on another worksheet

The cells in Cols C, D, E, F, etc etc all have a very clever formula for getting that date which is this (taken from F6)
=IFERROR(INDEX('Procurement Progress List'!F$6:F$2000,SMALL(IF(('Procurement Progress List'!$A$6:$A$2000)="OUTSTANDING",MATCH(ROW('Procurement Progress List'!$A$6:$A$2000),ROW('Procurement Progress List'!$A$6:$A$2000))),ROW(D1))),"")

BUT, what I want the sheet to look like is this (edited in paint to show what I want)

At first it might not be massively noticeable what I'm after but basically I want to narrow down Col F and have the text (that is the result of the formula) be visible in full.



But if you dimply narrow down column F you get this, which is the text disappearing under the next cell in Col G

It does this because the cells in G have the formula
=IFERROR(INDEX('Procurement Progress List'!G$6:G$2000,SMALL(IF(('Procurement Progress List'!$A$6:$A$2000)="OUTSTANDING",MATCH(ROW('Procurement Progress List'!$A$6:$A$2000),ROW('Procurement Progress List'!$A$6:$A$2000))),ROW(E1))),"")
..and obvioulsy the contents of G6 cannot be blocked by anything in F6.

So, to all you wonderful people, if this even possible to do and if so, HOW!!!!

HAve a great day all.

Be sfae

D

 

[maabadi]

It is Very Better to upload your example file & Desired Results with XL2BB ADDIN.
But try this:

=if(I6="",IFERROR(INDEX('Procurement Progress List'!G$6:G$2000,SMALL(IF(('Procurement Progress List'!$A$6:$A$2000)="OUTSTANDING",MATCH(ROW('Procurement Progress List'!$A$6:$A$2000),ROW('Procurement Progress List'!$A$6:$A$2000))),ROW(E1))),""),IFERROR(INDEX('Procurement Progress List'!F$6:F$2000,SMALL(IF(('Procurement Progress List'!$A$6:$A$2000)="OUTSTANDING",MATCH(ROW('Procurement Progress List'!$A$6:$A$2000),ROW('Procurement Progress List'!$A$6:$A$2000))),ROW(D1))),""))