Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Matching
Ok, here is the issue. I have a report that is sent to me with a list of all
the expenses (by name) and there expenses next to it. The next month I recieve the report again and what I would like to do is show a monthly trend by showing the expenses month by month, but when I recieve the report the following month, the expenses are not all the same and/or not in the same order. Is there any way of matching them on excel, and the ones that do not match I can just add to the bottom? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Matching
Expenses by name is tough. Consider assigning a unique number to each
expense. That way they can be easily matched & tracked month-by-month. -- Gary''s Student - gsnu200781 "AlexD" wrote: Ok, here is the issue. I have a report that is sent to me with a list of all the expenses (by name) and there expenses next to it. The next month I recieve the report again and what I would like to do is show a monthly trend by showing the expenses month by month, but when I recieve the report the following month, the expenses are not all the same and/or not in the same order. Is there any way of matching them on excel, and the ones that do not match I can just add to the bottom? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Matching identical data using data only once in the matching proce | Excel Discussion (Misc queries) | |||
Help with Matching Text Fields - Then Moving the Matching Cells Side by Side | Excel Discussion (Misc queries) | |||
matching | Excel Worksheet Functions | |||
Matching | Excel Discussion (Misc queries) | |||
Matching data and linking it to the matching cell | Links and Linking in Excel |