Add two unique values from two separate columns
I am trying to figure out how many months a salesman has worked in a given year. example: Column A has Salesman A, Salesman B and Salesman C. Column B has the date. Some salesman will have multily sales in a month. How can I ask excel to tell me how many months a salesman has worked.
Salesman A 1/5/11
Salesman B 1/5/11
Salesman B 1/10/11
Salesman A 2/15/11
Salesman B 2/20/11
Salesman C 2/25/11
Answer should be
Salesman A = 2
Salesman B = 2
Saleman C = 1
Last edited by Mrcoop; 09-27-2011 at 08:58 PM. Reason: was asked to
see attatchment
this could be done through two helper columns and then sum through sumif or pivot table
Azam
If you want to say Thank you to a member, click the reputation icon (Star) in the left bottom of the post.
For prompt answer, be descriptive, concise, short, direct, and to-the-point.
Or this, without helper column:
Never use Merged Cells in Excel
Hi zbor
this formula do not give correct answer if a salesman do not work or work after gap of a month. see attatchment
This formula is actually calculating the maximum no of months between dates
the data range in the formula cell H3 and H4 is also not correct
Last edited by Azam Ali; 09-28-2011 at 05:28 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks