Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how can I solve this problem? Please help me | Excel Discussion (Misc queries) | |||
Pls help me to solve this problem... | Excel Worksheet Functions | |||
Please solve this problem. | Excel Worksheet Functions | |||
simple average formula...can you solve it in principle? | Excel Discussion (Misc queries) | |||
Can someone solve a problem for me? | Excel Discussion (Misc queries) |