ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Matching (https://www.excelbanter.com/excel-discussion-misc-queries/185105-matching.html)

alexd

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?

Gary''s Student

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?



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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com