LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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!


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how can I solve this problem? Please help me theinzaw Excel Discussion (Misc queries) 0 December 13th 08 12:09 PM
Pls help me to solve this problem... Bradley Excel Worksheet Functions 13 July 21st 07 02:40 AM
Please solve this problem. ramulu Excel Worksheet Functions 1 February 15th 07 07:43 AM
simple average formula...can you solve it in principle? krasavchik Excel Discussion (Misc queries) 2 April 25th 06 06:48 PM
Can someone solve a problem for me? Jon Parker Excel Discussion (Misc queries) 1 April 25th 05 11:14 PM


All times are GMT +1. The time now is 10:23 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"