View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
golddave via OfficeKB.com golddave via OfficeKB.com is offline
external usenet poster
 
Posts: 11
Default Display an Array of Data Based on Other Data

Actually, one invoice group begins with the letters G-S. The other group
begins with the letters A-F and T-W. (There are no invoices for X, Y & Z).

golddave wrote:
Maximum number per customer is probably 10. Also, I just got a requirement
that there may be 2 classifications of invoices. So there will be a column E
that lists some of them. I'll have to figure out how to parse them based on
cell ranges (I think).

What is the maximum number of multiple-orders that you are likely to
encounter? Your example shows 2 for Pujols and Wright.

[quoted text clipped - 6 lines]
--
Message posted viahttp://www.officekb.com


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200909/1