View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Carl S. Carl S. is offline
external usenet poster
 
Posts: 11
Default Can't solve simple? problem. Can some genius out there help!

Want to pull simple data from two tables/sheets into a third and use formulas
(array or otherwise), not macros or filters. I only want to select rows for
customer CARL. Below is the example:

Table Deposits (First Table, one data source)
Customer Date Deposit
Carl 1/25/2008 $150,000.00
Carl 2/28/2009 $50,000.00
Joe 3/5/2008

Table Withdrawls (2nd Table another data source)
Customer Date Withdrawl
Carl 1/28/2008 (6000)
Joe 3/1/2008 (3000)
Carl 4/12/2008 (4000)
Joe 5/5/2008 (7000)

The desired final result is listed below. The column with the name CARL can
be omitted...just here to show the result data.

Customer Date Depost Withdrawl
Carl 1/25/2008 $150,000.00
Carl 1/28/2008 (6000)
Carl 2/28/2009 $50,000.00
Carl 4/12/2008 (4000)

Thanks for any help offered!!! Whatever FORMULAS are arrived at will be
greatly appreciated!