damian_r_Home
Board Regular
- Joined
- Jan 8, 2005
- Messages
- 231
- Office Version
- 365
- 2007
- Platform
- Windows
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
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