ollyhughes1982
Well-known Member
- Joined
- Nov 27, 2018
- Messages
- 677
- Office Version
- 365
- Platform
- MacOS
Hi,
I have a VSTACK formula, that had up until now appeared to have been working. However, now that my data has changed slightly I have encountered an issue. My formula is as below:
I thought that I had catered for ranges with no data via the <>"" in each filter function, but it doesn't seem to be working. Now that KZN (SA)'!A4:A2003 and NW R (SA)'!A4:A2003 don't currently have any data, the formula is not working. Do I need some sort filter wrapped around the entire thing, perhaps before the '(VSTACK' part of the formula?
If I remove the IFERROR function, I can see that it's a CALC error that I'm getting.
Thanks in advance!
Olly.
I have a VSTACK formula, that had up until now appeared to have been working. However, now that my data has changed slightly I have encountered an issue. My formula is as below:
Excel Formula:
=IFERROR(SORT(VSTACK(FILTER('All Completed Runs - EC (SA)'!A4:A2003,'All Completed Runs - EC (SA)'!A4:A2003<>""),FILTER('All Completed Runs - FS (SA)'!A4:A2003,'All Completed Runs - FS (SA)'!A4:A2003<>""),FILTER('All Completed Runs - GT (SA)'!A4:A2003,'All Completed Runs - GT (SA)'!A4:A2003<>""),FILTER('All Completed Runs - KZN (SA)'!A4:A2003,'All Completed Runs - KZN (SA)'!A4:A2003<>""),FILTER('All Completed Runs - LI R (SA)'!A4:A2003,'All Completed Runs - LI R (SA)'!A4:A2003<>""),FILTER('All Completed Runs - MP R (SA)'!A4:A2003,'All Completed Runs - MP R (SA)'!A4:A2003<>""),FILTER('All Completed Runs - NW R (SA)'!A4:A2003,'All Completed Runs - NW R (SA)'!A4:A2003<>""),FILTER('All Completed Runs - NC R (SA)'!A4:A2003,'All Completed Runs - NC R (SA)'!A4:A2003<>""),FILTER('All Completed Runs - WC (SA)'!A4:A2003,'All Completed Runs - WC (SA)'!A4:A2003<>"")),,,-1),"")
I thought that I had catered for ranges with no data via the <>"" in each filter function, but it doesn't seem to be working. Now that KZN (SA)'!A4:A2003 and NW R (SA)'!A4:A2003 don't currently have any data, the formula is not working. Do I need some sort filter wrapped around the entire thing, perhaps before the '(VSTACK' part of the formula?
If I remove the IFERROR function, I can see that it's a CALC error that I'm getting.
Thanks in advance!
Olly.