Thread: [Solved] Invoices arrangement
View Single Post
 
Old 12-06-2015, 11:07 PM
xor xor is offline Windows 10 Office 2013
Expert
  
Join Date: Oct 2015
Posts: 1,097
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default Invoices arrangement
Quote:
Originally Posted by macropod View Post
Why do you say you need "another solution by code"? What is wrong with using the formula solution you have already been given?

Note: if you don't want to use named ranges, you could change xor's array formula to:
=IF(ROWS($1:1)>COUNT($E:$E),"",INDEX($E:$E,SMALL(I F($E:$E<>"",ROW($E:$E)-CELL("row",$E:$E)+1),ROWS($1:1)+1)))
on row 7, then copy down as far as needed.

With all due respect I think it is about the worst advice one could give to propose full column references in array formulas.

See for example:
https://msdn.microsoft.com/enus/libr...rraySumProduct
Reply With Quote