LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default matching rows from month to month

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
excel to make the days cary over month to month automaticly GARY New Users to Excel 1 April 19th 08 06:05 PM
matching month and year column. earls Excel Worksheet Functions 4 December 28th 06 08:47 PM
Return across Row Numeric Values Matching EXACT Month & Year for Criteria Sam via OfficeKB.com Excel Worksheet Functions 8 October 22nd 06 11:30 PM
Matching month part of date only RGB Excel Discussion (Misc queries) 4 July 17th 06 02:44 PM
Matching the month and year portion of a date only RGB Excel Discussion (Misc queries) 1 June 9th 06 05:43 PM


All times are GMT +1. The time now is 12:39 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"