Invoices arrangement

tofimoon4 · #1 12-03-2015, 12:42 AM

Dear sir,i need your help by another solution by code .
Best regards .

macropod · #2 12-06-2015, 05:02 AM

Quote:

Originally Posted by tofimoon4

Dear sir,i need your help by another solution by code .

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.

xor · #3 12-06-2015, 11:07 PM

Quote:

Originally Posted by macropod

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
numbering invoices	michael37150	Word	12	11-01-2015 01:43 AM
Data Arrangement	Haha88	Excel	3	06-19-2015 03:04 PM
Help making invoices easier	wbowles	Office	0	07-17-2013 10:39 AM
Creating Invoices from CSV	iansan5653	Excel	5	02-07-2012 05:05 PM
Bothsided Text Arrangement - NOT working	Sleeper	Word	1	07-26-2011 04:35 PM