matching rows from month to month

[easyec99]

I am trying to compare Jan and Feb info that needs to be arranged by sales
person. The problem is that in Jan I have 434 sales people and in Feb there
are 474. Some are in Jan that aren't in Feb and vice versa. What is the
most direct way to get these matched up in the same row for comparison. I
have done it by grouping them all and then finding the unique value and using
the sum if function to pull the sales for each month. I was just curious if
there was a simpler method.

 

[Fred Smith]

The best way would be to put all your data, including a column for the
month, in one spreadsheet. Then create a pivot table.

If a salesperson is in one month, but not the other, the pivot table will
show blank for the month.

Pivot tables are well worth the effort to learn, and will save you a lot of
time once you do.

Regards,
Fred.