Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
excel to make the days cary over month to month automaticly | New Users to Excel | |||
matching month and year column. | Excel Worksheet Functions | |||
Return across Row Numeric Values Matching EXACT Month & Year for Criteria | Excel Worksheet Functions | |||
Matching month part of date only | Excel Discussion (Misc queries) | |||
Matching the month and year portion of a date only | Excel Discussion (Misc queries) |