Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I would like to have one table with the names of people with an amount of
money owed combined with the length of time it has been owed. So something like: Name 0-15 16-30 30+ Bill 12.75 0 32.16 Steve 0 5 75.25 And another table with the name of a person an amount of money owed and the date that it is owed from. So something like: Name Date Fee Bill 2/3/04 32.16 Steve 5/4/05 50 Steve 6/28/05 25.25 Steve 7/8/05 5 Bill 7/28/05 8.75 Bill 8/1/05 4 I would like for the first chart to be able to look up the data from the second chart and add it up and place it in the appropriate row under the correct range of dates. Thanks, Ray |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Lookup and Display Multiple Unique values based on criteria | Excel Worksheet Functions | |||
Lookup and Display Multiple Unique values based on criteria | Excel Worksheet Functions | |||
how to lookup the values from multiple columns? | Excel Discussion (Misc queries) | |||
Lookup all values within multiple columns and copy to new column | Excel Discussion (Misc queries) | |||
Lookup in Multiple Columns, Return Multiple Values | Excel Worksheet Functions |