Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi,
Would like to go about w/ with this. One with fees and the other with refer. the one with fees looks like this; settlement Date: 06/01/09 (Merchant) (date) (Sales amount) (fee) (settlement Amount) 1234 05/29/09 450.00 25.00 425.00 1234 05/29/09 200.00 10.00 190.00 Total 615.00 settlement Date: 06/02/09 (Merchant) (date) (Sales amount) (fee) (settlement Amount) 4321 05/30/09 210.00 10.00 200.00 4321 05/30/09 650.00 50.00 600.00 Total 800.00 the other with refer. Which I want to input into the one with fees (Date) (Merchant) (Amount) (Refer.) 06/01/09 1234 615.00 1 06/02/09 4321 800.00 2 How can I go about inputting the refer. into one with fees. and also how can I cross reference. how can i check if the one w/ fees is missing in the other one. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
match totals with two lists of total | Excel Discussion (Misc queries) | |||
Match total with excel 2007 | Excel Discussion (Misc queries) | |||
match name and show total result | Excel Discussion (Misc queries) | |||
Finding combinations to match a total | Excel Discussion (Misc queries) | |||
calculating course fees | New Users to Excel |