Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-29-2015, 12:51 AM
tofimoon4 tofimoon4 is offline Invoices arrangement Windows XP Invoices arrangement Office 2003
Novice
Invoices arrangement
 
Join Date: Mar 2012
Posts: 13
tofimoon4 is on a distinguished road
Default 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 .
Attached Files
File Type: xls Book1.xls (17.5 KB, 15 views)
Reply With Quote
  #2  
Old 11-29-2015, 03:50 AM
xor xor is offline Invoices arrangement Windows 10 Invoices arrangement 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

See the attached

inv_no.xls
Reply With Quote
  #3  
Old 11-29-2015, 10:39 PM
tofimoon4 tofimoon4 is offline Invoices arrangement Windows XP Invoices arrangement Office 2003
Novice
Invoices arrangement
 
Join Date: Mar 2012
Posts: 13
tofimoon4 is on a distinguished road
Default

Dear sir , many thanks for this nice formula , any other help by code.
Best regards .
Reply With Quote
  #4  
Old 12-03-2015, 12:42 AM
tofimoon4 tofimoon4 is offline Invoices arrangement Windows XP Invoices arrangement Office 2003
Novice
Invoices arrangement
 
Join Date: Mar 2012
Posts: 13
tofimoon4 is on a distinguished road
Default

Dear sir,i need your help by another solution by code .
Best regards .
Reply With Quote
  #5  
Old 12-03-2015, 02:00 AM
tofimoon4 tofimoon4 is offline Invoices arrangement Windows XP Invoices arrangement Office 2003
Novice
Invoices arrangement
 
Join Date: Mar 2012
Posts: 13
tofimoon4 is on a distinguished road
Default

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 .
Reply With Quote
  #6  
Old 12-06-2015, 02:56 AM
tofimoon4 tofimoon4 is offline Invoices arrangement Windows XP Invoices arrangement Office 2003
Novice
Invoices arrangement
 
Join Date: Mar 2012
Posts: 13
tofimoon4 is on a distinguished road
Default

Dear sir,with best regards,is it possible to send my request to another forum to get any reply ?
Many thanks .
Reply With Quote
  #7  
Old 12-06-2015, 03:15 AM
xor xor is offline Invoices arrangement Windows 10 Invoices arrangement 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

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).
Reply With Quote
  #8  
Old 12-06-2015, 05:02 AM
macropod's Avatar
macropod macropod is offline Invoices arrangement Windows 7 64bit Invoices arrangement Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Quote:
Originally Posted by tofimoon4 View Post
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.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #9  
Old 12-06-2015, 11:07 PM
xor xor is offline Invoices arrangement Windows 10 Invoices arrangement 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
  #10  
Old 12-06-2015, 11:56 PM
macropod's Avatar
macropod macropod is offline Invoices arrangement Windows 7 64bit Invoices arrangement Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Invoices arrangement 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
Invoices arrangement Creating Invoices from CSV iansan5653 Excel 5 02-07-2012 05:05 PM
Invoices arrangement Bothsided Text Arrangement - NOT working Sleeper Word 1 07-26-2011 04:35 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:20 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft