#1
|
|||
|
|||
Invoices arrangement
Dear sir,with best regards,asking you kindly for help by arranging the invoices as mentioned in attached schedule .( by code and formula )
Many thanks in advance . |
#2
|
|||
|
|||
|
#3
|
|||
|
|||
Dear sir , many thanks for this nice formula , any other help by code.
Best regards . |
#4
|
|||
|
|||
Dear sir,i need your help by another solution by code .
Best regards . |
#5
|
|||
|
|||
Dear sir ,with best regards,where is the problem,the subject was different between two posts and i need help from anyone.
If this procedure was contrary with instructions , please consider my request as canceled. My apology . |
#6
|
|||
|
|||
Dear sir,with best regards,is it possible to send my request to another forum to get any reply ?
Many thanks . |
#7
|
|||
|
|||
If you can't use the solution I proposed then I would recommend you to post a new question. I am not able to help you with VBA (if that's what you want).
|
#8
|
||||
|
||||
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.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#9
|
|||
|
|||
Invoices arrangement
Quote:
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 |
#10
|
||||
|
||||
You're entitled to that view, of course, and I wasn't trying to suggest this was necessarily the best way of handling things; only showing that it could be done without resorting to named ranges. And, since neither of us knows the extent of the OP's data, I took the quick & dirty approach to showing how your formula could be adapted. Ideally, one would specify only as much of a range as is needed for the calculations.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
Thread Tools | |
Display Modes | |
|
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 |